how to get datetime from sql server

It seems to me a simple question, have you tried to search on google ?


http://blog.sqlauthority.com/2007/06/21/sql-server-retrieve-current-date-time-in-sql-server-current_timestamp-getdate-fn-now/[^]

try this link
http://blog.sqlauthority.com/2008/08/01/sql-server-2008-get-current-system-date-time/[^]
http://blog.sqlauthority.com/2007/06/21/sql-server-retrieve-current-date-time-in-sql-server-current_timestamp-getdate-fn-now/[^]

there are a couple of ways you can do this depending on how accurate you want the date and also weather it must be local server time or not

SELECT SYSDATETIME() as [SYSDATETIME]
    ,SYSDATETIMEOFFSET() as [SYSDATETIMEOFFSET]
    ,SYSUTCDATETIME() as [SYSUTCDATETIME]
    ,CURRENT_TIMESTAMP as [CURRENT_TIMESTAMP]
    ,GETDATE() as [GETDATE]
    ,GETUTCDATE() as [GETUTCDATE];