Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    47

    Unanswered: date transformation

    What is the fonction to use in order to format a date to char?
    for instance have the date under the following format :
    ddmmyy or dd/mm/yyyy ...

    Thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    80
    CONVERT ( varchar [ ( length ) ] , date-expression [ , style ] ).

    go thru cast and convert functions in BOL.

Posting Permissions

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