Re: OPO: Date as a default condition

From: Srinivasa Kunamneni <eleeb02_at_menudo.uh.edu>
Date: 1996/06/22
Message-ID: <4qgtqn$nn4_at_masala.cc.uh.edu>#1/1


Jason Byors (jbyors_at_earthlink.net) wrote:
: I am having trouble using a date as a default condition. I want the
: default condition to be something akin to: period = '12/31/95'
 

: I have tried using some of the following variations:
 

: period = '12/31/95'
: period = #12/31/95#
: period = to_date('12/31/95')

: Does anyone know what the proper syntax is. Thank you in advance.
 

: jb

Use:

    period = '31-DEC-95'
    or
    period = to_date('12/31/95','MM/DD/YY')     or
    period = to_date('12/31/1995','MM/DD/YYYY')     .
    ...

    check date formatting

Srini Kunamneni Received on Sat Jun 22 1996 - 00:00:00 CEST

Original text of this message