Home Forums SQL Server 2005 T-SQL (SS2K5) convert from MM/DD/YYYY to YYYYMMDD RE: convert from MM/DD/YYYY to YYYYMMDD

  • October 25, 2007 at 2:42 am

    #745268

    you can use date Style numbers to convert to different date formats

    here is an example for converting current date to different formats

    select CONVERT( varchar(10), getdate(), 111 )

    or

    select CONVERT( varchar(10), getdate(), 112 )

    where 111,112 are different data style number.

    Regards,

    Amit kulkarni