SELECT CONVERT(SMALLDATETIME,GETDATE(),20) ...i want the date to be 2010-02-02

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • zolamdlankomo
    New Member
    • Sep 2010
    • 1
    #1

    SELECT CONVERT(SMALLDATETIME,GETDATE(),20) ...i want the date to be 2010-02-02

    (SMALLDATETIME, GETDATE(),20) ...i want the date to be 2010-02-02. wen i run the statement above it gives mt todays dat bt i want 2010-02-02
    Tags: None
    • OraMaster
      New Member
      • Aug 2009
      • 135
      #2
      Can you provide more details on exactly what you required?

        Comment

        Previous template Next
        Working...