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!

sql date for msaccess

Status
Not open for further replies.
neoxaml

neoxaml

Programmer
Joined
Apr 24, 2009
Messages
5
Location
US
Is there a sql way to convert data "01/04/2008 1430" to appear as 2008/04/01?
 
Sort by date Sort by votes
In msacces you may use something like this:
SELECT Mid(yourTextField,7,4) & Mid(yourTextField,3,4) & Left(yourTextField,2)
FROM yourTable

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
txs, ended up doing the following:

Mid(left(Job.LastModified, 10), 5, 8) & '/' & Mid(left(Job.LastModified, 10), 3, 2) & '/' & Mid(left(Job.LastModified, 10), 1, 2)

AS Dates
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question Question
windows command in a sql script
Replies
1
Views
598
carp
carp
mmiah1982
  • Locked
  • Question Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
558
mmiah1982
mmiah1982
Tetol
  • Locked
  • Question Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
583
carp
carp
jchewsmith
  • Locked
  • Question Question
SQL Syntax
Replies
1
Views
533
JarlH
JarlH
jchewsmith
  • Locked
  • Question Question
Update Query with a MAX(Date) subquery
Replies
1
Views
676
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top