Default value of UNIX_TIMESTAMP()

[Kryptix]

I use UNIX_TIMESTAMP() a lot, is there anyway I can use that as a default value? It's a INT(10) and if I put UNIX_TIMESTAMP() in it says it's invalid.

[jskywalker]

can you give some more info on HOW you are trying to update a field with UNIX_TIMESTAMP()

als please specify how you defined the table you are trying to update

[Mchl]

Use TIMESTAMP field instead and set default value to CURRENT_TIMESTAMP

[jskywalker]

Use TIMESTAMP field instead and set default value to CURRENT_TIMESTAMP

Than i would prefer NOW()

Just because its shorter...

 

And NOW() is the same as FROM_UNITIME(UNIX_TIMESTAMP())

[Mchl]

Use TIMESTAMP field instead and set default value to CURRENT_TIMESTAMP

Than i would prefer NOW()

Just because its shorter...

 

And NOW() is the same as FROM_UNITIME(UNIX_TIMESTAMP())

 

Except, as OP has already find out, you can't use function as a default value.

[Kryptix]

Hm, this is confusing. Is MySQL's TIMESTAMP the same as TIME() in PHP and UNIX_TIMESTAMP() in MySQL? I have thousands of database entries and it would be a pain to switch.

[Mchl]

No it's not the same. TIMESTAMP columns return time in YYYYMMDDHHMMSS format.

No it wouldn't be a pain. You need three, at most four queries to do it (and change your PHP code).