Re: SQL*FORMS and date format filling
From: <fgreene_at_hayes.com>
Date: 20 Sep 93 07:23:31 EDT
Message-ID: <8003.2c9d5a73_at_hayes.com>
Date: 20 Sep 93 07:23:31 EDT
Message-ID: <8003.2c9d5a73_at_hayes.com>
In article <1993Sep17.193814.4214_at_macc.wisc.edu>, dly_at_vms.macc.wisc.edu writes:
> We are using ORACLE 7.0.12, SQL*FORMS 3.0 on Sun OS 4.1.3
>
> We have a form with type DATETIME, format MM/DD/YY HH:MM:SS
> How can I force ORACLE to put the year as 1993 instead of 0093 using
> this format?
>
> -- Debbie Yoshihara
> Department of Biostatistics
If you leave the format statement off the field, the system defaults to a four position year as in 12-SEP-1993 12:22:44
If you want to use a format statement, I believe all you need to do is define the year as YYYY Received on Mon Sep 20 1993 - 13:23:31 CEST