Skip to content
Advertisement

why “CURRENT_TIMESTAMP” showing wrong time in SQL?

I am using “CURRENT_TIMESTAMP” for automatic date setup inside the column for each row in SQL. It shows date and time but time is wrong. please help.

Advertisement

Answer

CURRENT_TIMESTAMP will show you the server timestamp not client side timestamp from where you are querying.
Please check in which timezone your database server is located.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement