Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: convert a gregorian date in mm/dd/yyyy

    I want to convert a gregorian date in mm/dd/yyyy format in MS SQL 2000.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Are you lookig to convert from one of the Gregorian calendars to the Julian calendar, or just present an existing DATETIME value in the format you specified? The conversion is an interesting problem, the presentation issue ought to be solved on the client rather than the server, although you can make yourself a LOT of trouble later on by just using:
    SELECT Convert(VARCHAR(30), GetDate(), 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