date time format

Hot Topic

Do I HAVE to specify configuration files in dtexec
Slow XML value() calls
Sql Server Compatibility : Null Values in Identity Column
Use View to speed up?
sorting on an expression
Subfolders
Report performance issue - time in processing
Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?
SQL Express Family CTP Now Available
Will package work on different CTP version?

SQL Server

deleting records
The user 'sa' does not have permission to register endpoint 'sql_endpoint' on the specified URL. Please ensure the URL refers t
Getting sample databases in Management Studio
Web Synchronization Update (Bug)
reportviewer control
Custom Destination Adapter
Cannot Open User Default Database (error 4064)
SQL 2005 specifications and performance documentation
Cannot change naming metadata
snapshot in SQL Server 2005

date time format

I want to retrieve a date time field from SQL server. The format I want it to be retrieved is:

YYYY/MM/DD-hh:mm:ss:lll (l = millisec)

example '2006/06/21-15:26:39:994'.

Can somebody please tell me how to do it. I know how to do it in Oracle, but not in SQL server.

Answer this question

date time format

  • ArtemB

    SELECT CONVERT(NVARCHAR(10), getdate(), 111) + '-' + RIGHT(CONVERT(NVARCHAR(23), getdate(), 21),12)

     

    Or

    SELECT REPLACE(REPLACE(CONVERT(NVARCHAR(23), getdate(), 127),'-', '/'), 'T','-')

  • san7

    theirs is better



  • A_Martin

    Did this answer your question or not

  • Gaurav Khera

    Thank you very much

  • Frank Hileman

    declare @test datetime
    set @test = getdate()
    select convert(varchar(100),@test,121)
    select convert(varchar(100),@test,120)
    select convert(varchar(100),@test,126)

    the third parameter is key here, which is the STYLE argument.
  • date time format
Answer this question