UNIX_TIMESTAMP getting null

Question

This is getting NULL, why?

select unix_timestamp(addtime(date(now()), time(from_unixtime(1426705199))))

For some reason, it is running correctly, however it only outputs NULL

symcbean · Accepted Answer · 2015-02-16 17:44:55Z

1

I often find, when confronted with an error, that the manual can be a useful resource:

ADDTIME() adds expr2 to expr1 and returns the result. expr1 is a time or datetime expression, and expr2 is a time expression.

You are using a date value for expr1. Try casting it back to datetime expression:

select unix_timestamp(addtime(
   timestamp(date(now()))
   , time(from_unixtime(1426705199))))

answered Feb 16, 2015 at 17:44

symcbean

48.4k6 gold badges63 silver badges99 bronze badges

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

Comments

score 0 · Accepted Answer · 2015-02-16 17:36:01Z

0

This should work?

 SELECT UNIX_TIMESTAMP(NOW())

If you want to get it from your own field then use this..

SELECT UNIX_TIMESTAMP(yourField);

answered Feb 16, 2015 at 17:28

user4561879

I want to generate hour:min from other field