Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    california
    Posts
    21

    Question Unanswered: date function - Urgent

    Hello Guys,

    I have just migrated from Oracle to MS SQl Server Database. I need to know a function in SQL for converting the date format - as there is in Oracle "to_date(value,'format') ?

    Can anyone help me please

    Thanks
    Astha

  2. #2
    Join Date
    May 2003
    Location
    CA, USA
    Posts
    1

    Re: date function - Urgent

    Originally posted by astha_raj
    Hello Guys,

    I have just migrated from Oracle to MS SQl Server Database. I need to know a function in SQL for converting the date format - as there is in Oracle "to_date(value,'format') ?

    Can anyone help me please

    Thanks
    Astha

    Hope the below helps.

    select myDate = convert(varchar(10),thevalue,101)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •