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 IamaSherpa 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
Apr 24, 2009
5
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
windows command in a sql script
Replies
1
Views
204
carp
carp
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
190
mmiah1982
mmiah1982
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
179
carp
carp
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
188
JarlH
JarlH
jchewsmith
  • Locked
  • Question
Update Query with a MAX(Date) subquery 1
Replies
1
Views
234
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top