Insert date and time as unix_timestamp in Mysql

Question

I'm trying to insert current date and time to activitystamp as unix_timestamp. But i just get 0 as result.

INSERT INTO `skadate`.`ow_base_user_online` (`id`, `userId`, `activityStamp`, `context`, `misc`) 
VALUES (NULL, '1402', 'UNIX_TIMESTAMP()', '1', '1');

you're not calling a function. you're passing a string which contains text that LOOKS like a function call. — Marc B
– Marc B, Commented Dec 17, 2014 at 18:41

John Conde · Accepted Answer · 2014-12-17 18:39:36Z

3

MySQL functions should not be in quotes:

INSERT INTO `skadate`.`ow_base_user_online` (`id`, `userId`, `activityStamp`, `context`, `misc`) 
VALUES (NULL, '1402', UNIX_TIMESTAMP(), '1', '1');

answered Dec 17, 2014 at 18:39

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

John Conde Over a year ago

It's usually a simple thing like that :)

Collectives™ on Stack Overflow

Insert date and time as unix_timestamp in Mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related