Home Forums SQL Server 2005 T-SQL (SS2K5) Set Variable based on a SELECT RE: Set Variable based on a SELECT

  • February 10, 2010 at 9:27 am

    #1116943

    1) Then when I do a SELECT on the DATETIME field in the TABLE, I get this:

    2010-02-10 08:12:00.000

    2) But when I use SSMS and do an OPEN TABLE to view the data, I get this:

    2/10/2010 8:12:00 AM

    When I do a SELECT on the data I want to "see" option 2 (2/10/2010 8:12:00 AM).

    So I assume I have to format my SELECT in order to CONVERT the value into the FORMAT I want to see?