TIMENOW() function

[Kevin_Vandeness]

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 !