(Msg. 2) Posted: Tue Nov 07, 2006 9:31 am
Post subject: Re: DateTime Format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> Hello All,
>
> Is it possible to store the date as ' 02 - Apr - 2006 ' in the SQL
> datetime field? If it is please tell how to do.
>
> Thanks,
> karthick
>
Convert to DateTime format - Hi, I have a value like 'Mon, 25 Sep 2006 10:00:00' saved in a varchar field. How can I convert this to datetime format? I want the above value to be converted to '10/25/2006 10:00:00 AM' format. Thanks in advance.
Convert DateTime to Date format - How do I convert a datetime field to date only? I would like to convert: 2008-10-31 12:23:30 to 31/10/2008
Default date format for convert(datetime,TextDate) - Hello: I have a web application with a lot of stores procedures running under SQL Server 2000 in English but the languaje of the application is Spanish. In many of these stored procedures there are transformations of text dates like ..
SSIS - Datetime Format in SQL Command Variable - I know I should post this in the SSIS group, but this gets a lot more traffic and I'm hoping someone here can help me. I have a package variable called "TradeDate" that is a DatetTime data type and the value comes from a SQL Secect stateme...
SQL SERVER 2005 DATETIME format inconsistency between sele.. - Sending out an S.O.S to the world ...Help problem: The format of datetime column differs on select and on update/insert queries. installed system. SQL server express 2005 on windows 2003 web server edition regional settings greek (also tried UK english...
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum