SQL NOW() function not working properly

Question

I'm trying to insert the date in a a query, using the NOW() statement.

However only the Y-m-d are being inserted correctly, while the hours, minutes and seconds are all appearing zeros ( 00:00:00 )

Any reason for that?

Answer 1

Try this :

SELECT CURRENT_TIMESTAMP
or
SELECT GETDATE()
or
Select {fn NOW()}

Note the accolades in the function.

Answer 2

Did you check the type of the column you are inserting into? Make sure it's datetime, not just date.

Refer to the docs for more info.