Post reply

Displaying Dates in particular format

  • September 23, 2005 at 4:17 am

    #166152

    Is there any way of displaying SQL dates in the following format:

    ddmmmyyyy

    i.e. 01Apr2005

    Thanks in advance

     

    Carl

  • September 23, 2005 at 4:55 am

    #592545

    Discovered how to do it:

    select REPLACE(CONVERT(CHAR(11),[testdate],106), ' ','') AS [testdate]

    from testdate

    Carl

  • September 23, 2005 at 4:57 am

    #592546

    select replace(convert(char(11),cast('2005-09-23' as datetime),13),' ','')

  • September 23, 2005 at 5:36 am

    #592557

    Do you show data from database directly to end user? Without any front-end application?

    Define the presentation format is a task for a application, not SQL Server.

    _____________
    Code for TallyGenerator

  • September 26, 2005 at 2:28 am

    #592907

    Hi,

    The purpose of the formatting was for a report not a front end application.

     

    Regards

    Carl

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply