datetime data type - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

datetime data type

Author

Topic

sekar_r24
Starting Member

1 Post

Posted - 2007-10-16 : 05:10:30

hi friends.,

i using sql 2005 and using t-sql for creating queries. In my table i am having a date column. i need the date format as dd/mm/yyyy. i tried datetime data type. but i cannot get the output what i needed. it is attached with time format also.
i need help to set the date column in the format of dd/mm/yyy. can any one help??

thanks

sekar.r

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-16 : 05:19:20

Read about CAST & CONVERT in Books Online.
Or see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80563

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-10-16 : 07:01:00

Also, if you want to show data in front end, you can use format function there

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources