[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
? -Reply
- Subject: ? -Reply
- From: Emory Slifka <Eslifka@REEDREF.COM>
- Date: Wed, 2 Sep 1998 16:03:30 -0400
When you are selecting from the database you can't reformat a date by
using 'to_date' you have to use 'to_char'.
The 'to_date' option is to convert character strings into dates, the
'to_char' will convert a date into a character format that can be used in
your comparison.
Try to_char(pay_end_dt, 'DD-MON-YYYY'), this will retrieve the date
back as '30-AUG-1998', then compare the two character strings.
Good luck.