1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

SQL to get date from datetime field

Discussion in 'Database' started by Saloni Upadhyay, Jan 13, 2010.

  1. Saloni Upadhyay

    Saloni Upadhyay New Member

    select convert(varchar,Datecolumn,101)
    101 ->mm/dd/yyyy
    108 ->hh:mm:ss
    103 ->dd/mm/yyyy

    Function for getting current date in sql --> getdate()
  2. SpOonWiZaRd

    SpOonWiZaRd Know what you can do.

    Welcome to G4E, is that a question?
  3. shabbir

    shabbir Administrator Staff Member

    Moved to DB forum

Share This Page