SQL Server 2000 date issue

Results 1 to 2 of 2

Thread: SQL Server 2000 date issue

  1. #1
    Join Date
    Dec 1969

    Default SQL Server 2000 date issue

    HI,<BR>I have a table of holidays around the globe.<BR>I have a page that shows each day which holidays are occuring.<BR>I have a few dates that could be read as two dates, ie:<BR>10/11/2003 - november 10th, or october 11th. When I query the DB it gives this date on both of the options.<BR>Is there a way to the sql 2k server to read the dates in a specific way?<BR><BR>Thanks<BR><BR>Tom

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default use the convert function

    convert(datetime, ColumnName, 101) for mm/dd/yyyy format<BR><BR><BR>check the docs for the other options<BR><BR><BR>

Posting Permissions

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