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

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

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

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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:
    Code:
    SELECT Convert(VARCHAR(30), GetDate(), 101)
    -PatP

Posting Permissions

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