Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

DateTime Format

 
   Database Help (Home) -> Programming RSS
Next:  SELECT from list  
Author Message
k.karthikit

External


Since: Nov 07, 2006
Posts: 1



(Msg. 1) Posted: Tue Nov 07, 2006 12:17 am
Post subject: DateTime Format
Archived from groups: microsoft>public>sqlserver>programming (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

 >> Stay informed about: DateTime Format 
Back to top
Login to vote
Tibor Karaszi

External


Since: Jan 29, 2004
Posts: 1559



(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?)

Datetime isn't stored in *any* human readable format. See
http://www.karaszi.com/SQLServer/info_datetime.asp for details.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


wrote in message

> 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
>

 >> Stay informed about: DateTime Format 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
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...
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
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



[ Contact us | Terms of Service/Privacy Policy ]