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!

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
418
carp
carp
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
369
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
381
carp
carp
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
364
JarlH
JarlH
jchewsmith
  • Locked
  • Question
Update Query with a MAX(Date) subquery 1
Replies
1
Views
452
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top