Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DateTime conversion

Status
Not open for further replies.
zishan619

zishan619

Programmer
May 28, 2003
284
MX
Hi I need to know how to convert 01/01/2004 12:00:00 pm to
01/01/04 in T-sql.
Thanks
 
Sort by date Sort by votes
Check out CONVERT or CAST in BOL.

--Angel [rainbow]
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)
 
Upvote 0 Downvote
declare @TestDate DateTime
set @TestDate = '01/01/2004 12:00:00 pm'
print Convert(Char,@TestDate,1)

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
273
Andrzejek
Andrzejek
G12Consult
  • Locked
  • Question
Implicit conversion from data type error
Replies
14
Views
364
Olaf Doschke
Olaf Doschke
TariqMehmod
  • Locked
  • Question
Datetime to hour 4
Replies
17
Views
208
dhookom
dhookom
Cpreston
  • Locked
  • Question
Conversion issue in 2016 1
Replies
9
Views
139
fredericofonseca
fredericofonseca
DaveInIowa
  • Locked
  • Helpful tip
Query Shortcut for Displaying All DateTime Conversion Styles
Replies
1
Views
59
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top