Re: Need help Datefield Retrieval like this mmddyyyy

[Kenny Melton <KMELTO1@TANDY.COM>]

Dominick,

Here's one solution:

SELECT TO_CHAR(START_DATE, 'MMDDYYYY')
FROM ?????
WHERE ?????

The results for today's date would be: 09231998

Hope this helps.

Kenny Melton
Tandy Information Services
kmelto1@tandy.com

-----Original Message-----
From: Dominick Logiudice [mailto:dlogiudice@PINE.VPCC.SUNYSB.EDU]
Sent: Wednesday, September 23, 1998 11:07 AM
To: Multiple recipients of list SQR-USERS
Subject: Need help Datefield Retrieval like this mmddyyyy


Say I have a field called start date on a oracle db
I want to retrieve in like this mmddyyyy

How would I do this with sqr

Thanks