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!

Date Conversion

Status
Not open for further replies.
deucesp97

deucesp97

MIS
Sep 14, 2000
13
US
I am using QMF to convert a character type into a date type.
Is this possible, if so how?

I ahve tried a few things but the recent is
SELECT DATE(ROUTE_DT)
FROM INVOICE;

The error message I am receiving is the datetime value is invalid. [sig][/sig]
 
Status
Not open for further replies.

Similar threads

cloudtwter
  • Locked
  • Question
CASE DATE
Replies
5
Views
322
cloudtwter
cloudtwter
visitor12
  • Locked
  • Article
db2 TIME STAMP CONVERSION
Replies
0
Views
269
visitor12
visitor12
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
684
ANGELDANY
ANGELDANY
simeet7
  • Locked
  • Question
Help with Dates
Replies
1
Views
315
fredericofonseca
fredericofonseca
Ams16
  • Locked
  • Question
Get rows without a specific date
Replies
2
Views
264
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top