TIMENOW() function

Hello everyone,

I have a little problem with my app. I’d like to show the exact time when I save my data. To do that :

  • My column name is " Horodateur "
  • Type is DateTime
  • Initial value is TIMENOW()

But it doesn’t work. I got, as result, a date and a time and the worst is that the date begins at 30/12/1899.

Can you help me please ? I just want to indicate the exact time (HOUR:MINUTE) of the day.
Thank you in advance !

1 Like

Hello Steve,

Thank you for your answer. I have already read this page and tried the function TIMENOW() but it doesn’t work.

You should use initial value of NOW()

TODAY() retunds a Date. TIMENOW() returns just a Time. NOW() returns a DateTime.

Your column is currently a DateTime which means it will contain a Date and a Time, hence DateTime. Make sure you use the appropriate column type in conjunction with the function you want.