Re: Newbie question - formatting date/time

From: Pradhan <empradhan_at_dplus.net>
Date: Sun, 13 Jun 1999 14:44:35 -0400
Message-ID: <pZS83.3213$m93.15461@newsfeed.slurp.net>

You are quite right you need to mask with the date format as

where exec_date=to_Date('11-JUN-1999 18:58:21','DD-MON-YYYY HH24:MI:SS')

good luck
pradhan

Eric wrote in message <7k0pr3$2ar$1_at_nntp9.atl.mindspring.net>...
>I think I need to use to_date, but I'm not sure how. For example, I want to
>retrieve rows
> WHERE exec_date = 11-jun-1999 6:58:21 PM
>
>How do I set this up in Oracle7 properly?
>
>TIA,
>Eric
>
>
Received on Sun Jun 13 1999 - 13:44:35 CDT