Results 1 to 3 of 3

Thread: Date Format

  1. #1
    Join Date
    May 2014

    Unanswered: Date Format

    When creating fields in MS SQL is there any way I can set the date format of the Date or DateTime characteristic to DD/MM/YYYY?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Yes, the actual format is binary but the display format is defined by the retrieval/display process. The mechanics of the formatting process depend on what tools you are using, but you can format the display as you see fit.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2013
    Provided Answers: 1
    Fields?? Columns are not anything like fields. What is a "characteric"? we never used that term in the ANSI Standards. You are still using the COBOL PICTURE field definitions!

    In ANSI/ISO Standard SQL, there is one and only one display format for temporal data; ISO-8601. That is yyyy-mm-dd HH:MMS; it is a fundamental idiom in many, many ISO Standards, not just SQL.

    We do not care what the internal representation is, just as our decimal display of numbers has nothing whatsoever with the internal (high end, low end, twos complement, ones complement, BCD, et al) representation.

    You can go to a presentation layer to screw up the data into any local hillbilly dialect you wish. The old Sybase legacy (family curse) will let you do this in the schema, too. Don't.

Posting Permissions

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