how to get current datetime in SQL

Question

Want to get current datetime to insert into lastModifiedTime column  I am using MySQL database  My questions are    is there a function available in SQL  or  it is implementation depended so each database has its own function for this  what is the function available in MySQL

User · Answer

GETDATE   or GETUTCDATE   are now superseded by the richer SYSDATETIME  SYSUTCDATETIME  and SYSDATETIMEOFFSET  in SQL 2008  Yes  I don t think ANSI has ever declared anything  and so each manufacturer has their own  That would be NOW     Hope this helps     Rob

User · Answer

Complete answer  1  Is there a function available in SQL  Yes  the SQL 92 spec  Oct 97  pg  171  section 6 16 specifies this functions  CURRENT TIME       Time of day at moment of evaluation CURRENT DATE       Date at moment of evaluation CURRENT TIMESTAMP  Date  amp  Time at moment of evaluation  2  It is implementation depended so each database has its own function for this  Each database has its own implementations  but they have to implement the three function above if they comply with the SQL 92 specification  but depends on the version of the spec  3  What is the function available in MySQL  NOW   returns 2009-08-05 15 13 00   CURDATE   returns 2009-08-05   CURTIME   returns 15 13 00

User · Answer

try this SELECT CURTIME    return 23 12 58 SELECT CURDATE    return 2020-11-12 SELECT NOW     return 2020-11-12 23 19 26 SELECT DAY now      return 12 SELECT DAYNAME now      return Thursday Hope this would be helpful for you

User · Answer

Just an add on for SQLite you can also use    CURRENT TIME CURRENT DATE CURRENT TIMESTAMP   for the current time  current date and current timestamp   You will get the same results as for SQL  sql sqlite

User · Answer

NOW   returns 2009-08-05 15 13 00  CURDATE   returns 2009-08-05  CURTIME   returns 15 13 00

User · Answer

SYSDATETIME   2007-04-30 13 10 02 0474381 SYSDATETIMEOFFSET  2007-04-30 13 10 02 0474381 -07 00 SYSUTCDATETIME   2007-04-30 20 10 02 0474381 CURRENT TIMESTAMP 2007-04-30 13 10 02 047   GETDATE   2007-04-30 13 10 02 047  GETUTCDATE   2007-04-30 20 10 02 047   I guess NOW   doesn t work sometime and gives error  NOW  is not a recognized built-in function name   Hope it helps    Thank You  https   docs microsoft com en-us sql t-sql functions getdate-transact-sql

User · Answer

For SQL Server use GetDate   or current timestamp  You can format the result with the Convert dataType value format   Tag your question with the correct Database Server

User · Answer

I want my datetime  and I want it now     For MySQL  anyway

User · Answer

I always just use NOW     INSERT INTO table  lastModifiedTime  VALUES  NOW      http   dev mysql com doc refman 5 1 en date-and-time-functions html function now

[sql] how to get current datetime in SQL?

Examples related to sql

Examples related to database

Examples related to current-time