SQL Server Date

From: Ibrahim Shameeque ("Ibrahim)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 09:29:31 -0000

Hi
I know that SQL Server accepts date in the format yyyymmdd(20040325). I want
to know how to convert any US or UK date into the above format and then
insert it into the table's datetime column. Similarly while selecting from
the column I want to convert back to US or UK format. Any help would be
appreciated. Thanks 

-- 
--------------------------------
Ibrahim Shameeque
--------------------------------

Relevant Pages

  • Re: SQL Server Date
    ... "Ibrahim Shameeque" wrote in message news:eoPECQxEEHA.3812@TK2MSFTNGP10.phx.gbl... ... > I know that SQL Server accepts date in the format yyyymmdd. ... I want> to know how to convert any US or UK date into the above format and then> insert it into the table's datetime column. ...
    (microsoft.public.sqlserver.programming)
  • Re: I am trying to find invlalid dates in a field in atable
    ... Then hunt down and kill the stupid bastard who put dates into a ... His death will improve the data quality and coding ... but since anyone was free to use any date format, ... Rebuild the table with a DATETIME column see how much you can save. ...
    (microsoft.public.sqlserver.programming)
  • Re: Dates - Urgent
    ... In SQL, this means using a proper DateTime column. ... DateTime column to a VB Date variable should not generate any ambiguity. ... explicit dd/mmm/yyyy type format strings). ...
    (microsoft.public.vb.com)
  • Re: Subtraction when including the MOD() function
    ... Bob Phillips ... datetime column from the time column. ... The answer I get is -0.82 if the cell is formatted as a "Number". ...
    (microsoft.public.excel.worksheet.functions)
  • Re: SQL
    ... i have a field that has the date of birth's in the following format, ... i want to take this out of the date of births /, ... You should store dates in a DATETIME column, ... David Portas, SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)