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 Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date conversion 1

Status
Not open for further replies.
ddrake

ddrake

Technical User
Mar 19, 2003
92
Hi all,
Working in SQL 2K and I've got a column that stores values in a datetime format and look like this: 2006-05-11 11:11:11. I need to convert them or something so that only the date is shown and the time part is just 0s (00:00:00). Is there anyway to do that in SQL?

Thanks!!
 
Sort by date Sort by votes
thread183-1294157

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
243
dhookom
dhookom
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
371
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
150
Andrzejek
Andrzejek
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
146
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to get monther per part id from last date to current date and include remaining date ? 1
Replies
7
Views
199
JohnBayne
JohnBayne

Part and Inventory Search

Sponsor

Back
Top