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

Convert data format

Status
Not open for further replies.
neoxaml

neoxaml

Programmer
Joined
Apr 24, 2009
Messages
5
Location
US
How can I use sql to convert the following text field data 5/14/2009 to display as 2009-05-14. I am using a text field.

Thanks
 
Sort by date Sort by votes
Txs, that's exactly what I ended up using. Appreciate pointing me in right direction.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question Question
SQL data types in CREATE/ALTER TABLE queries
Replies
2
Views
3K
combo
combo
breezett93
  • Locked
  • Question Question
Brand new lock violations errors all over my database
Replies
11
Views
6K
dhookom
dhookom
ptrifile
  • Locked
  • Question Question
Format of Date from Query
Replies
2
Views
303
ptrifile
ptrifile
MattGreer
  • Locked
  • Question Question
Select the first maximum value from a set of data
Replies
10
Views
1K
MattGreer
MattGreer
BTilson
  • Locked
  • Question Question
Dealing With # In Imported Data
Replies
5
Views
447
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top