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

Date Field Format

Status
Not open for further replies.
strom99

strom99

MIS
Nov 28, 2000
126
US
I have the following field I am displaying in an HTML page

2003-04-15 14:48:18.25

How can I change my SQL to only show the
2003-04-15
or
04-15-2003
or
April 15 2003

Thanks
SQL Server 2000
 
Sort by date Sort by votes

select convert(varchar(10),'2003-04-15 14:48:18.25',101)
 
Upvote 0 Downvote
For better performance, you should handle data formatting from the front-end app rather than while retrieving the data from the DB, eg using ASP:

Code: 
Response.Write FormatDateTime(rs("date_field"), 2)

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
651
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
600
dhookom
dhookom
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
636
Andrzejek
Andrzejek
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
613
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
315
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top