Get Current System Date Time
Answers were Sorted based on User's Feedback
Answer / mohammadali.info
SELECT GETDATE() AS CurrentDateTime
SELECT 'SYSDATETIME' AS FunctionName, SYSDATETIME() AS DateTimeFormat
UNION ALL
SELECT 'SYSDATETIMEOFFSET', SYSDATETIMEOFFSET()
UNION ALL
SELECT 'SYSUTCDATETIME', SYSUTCDATETIME()
UNION ALL
SELECT 'CURRENT_TIMESTAMP', CURRENT_TIMESTAMP
UNION ALL
SELECT 'GETDATE', GETDATE()
UNION ALL
SELECT 'GETUTCDATE', GETUTCDATE()
| Is This Answer Correct ? | 4 Yes | 0 No |
what is statistics
What are the database roles? : sql server security
What is the datatype of rowid?
What is checkpoint in sql server?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is the difference between ‘having’ clause and a ‘where’ clause?
Why Do you want to work in this company?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Explain about extended stored procedure?
What are user-defined functions (udfs) in sql server?
Why do we need normalization?
Name the different type of indexes in sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)