Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    6

    Unanswered: How do you change date formats using "design table"

    I'm looking to change the format of the date in one of my columns, how do you do that?

    And what is the default date? Is Time included in that?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    There is no default date. You can define it as getdate(), convert(char(10), getdate(), 101), etc. Time is always included, but depending on your definition it may be either the time of the record creation (unless you perform arithmetics on the time portion) or midnight of the date.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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