urgent in date

Results 1 to 2 of 2

Thread: urgent in date

  1. #1
    kavitha Guest

    Default urgent in date

    hi i&#039m new to sqlserver..<BR>what syntax u use to get the system date in sqlserver<BR>In SqlServer, is the date length is fixed to 8,<BR>b&#039cos when i want to store a date value in &#039dd/mm/yyyy&#039 format<BR>what should i do..<BR><BR>thanx in advance<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: urgent in date

    in SQL use GetDate() to get the date on the server.<BR><BR>Dates are stored as a cryptic number internally in SQL server accurate to about 3 ms, but there will be a default output format usually<BR><BR>1 Jan 2000 00:00:00<BR><BR>to get the format you want use convert()<BR><BR>look up the formats available in you help file, but i think what you want is<BR><BR>select convert(char(10),getdate(),103)<BR><BR>col

Posting Permissions

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