Re: edit dd/mm/yyyy

[Arthur Coniglio <Arthur.CONIGLIO@EDDEPT.WA.EDU.AU>]

Thanks Gilbert

i should have mentioned that the dates i'm using are all in the format
of yyyy-mm-dd because
i do various date comparisons and additions etc.

i then convert the dates using the Convert-From-DTU-Date function to
convert it to the default oracle
database format of dd-mon-yyyy.  Once in this format we should be able
to use the edit function
with the print command to print in the required format.

Arthur Coniglio
Education Department of Western Australia

> -----Original Message-----
> From: Stokman, Gilbert [SMTP:Stokman.Gilbert@KPMG.NL]
> Sent: Wednesday, 28 January 1998 3:31
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: edit dd/mm/yyyy
> Importance:   High
>
> If I want to get a date field from the database 2 look like DD/MM/YYYY
> I
> do this:
>
> begin-select
> to_char(datefield,'DD/MM/YYYY')
>         move &to_char(datefield,'DD/MM/YYYY') to $begin_dt
> from ps_table
> end-select
>
> The $begin_dt var. is now containing a DD/MM/YYYY format date!
>
> Gilbert Stokman
> Cap Gemini Netherlands
>
> > ----------
> > From:         Arthur Coniglio[SMTP:Arthur.CONIGLIO@EDDEPT.WA.EDU.AU]
> > Reply To:     SQR-USERS@USA.NET
> > Sent:         woensdag 28 januari 1998 1:49
> > To:   Multiple recipients of list SQR-USERS
> > Subject:      edit dd/mm/yyyy
> > Importance:   High
> >
> > --- Virus checked / Op virussen gecontroleerd ---
> > G'day all.
> >
> > Can someone please tell me if you have ever used the   EDIT
> DD/MM/YYYY
> > function
> > with the print command.   I have a date in database format held in a
> > variable and attempting to
> > print it the format of my choice.  All i get printed to the report
> is
> > DD/MM/YYYY and not the
> > actual date ??
> >
> > Example.      print  $Begin-Dt     (,+5)     edit dd/mm/yyyy
> >
> > Has anyone had any luck with this.
> > Any ideas appreciated.
> >
> > Cheers
> > Arthur.
> >
>
> ======================================================================
> ==========
> De informatie verzonden met dit E-mail bericht is uitsluitend
> bestemd voor de geadresseerde.
> Gebruik van deze informatie door anderen dan de geadresseerde is
> verboden.
> Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van
> deze
> informatie aan derden is niet toegestaan.
> KPMG staat niet in voor de juiste en volledige overbrenging van de
> inhoud
> van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
> ======================================================================
> ==========
> The information contained in this communication is confidential
> and may be legally privileged.
> It is intended solely for the use of the individual or entity to whom
> it is addressed and others authorised to receive it.
> If you are not the intended recipient you are hereby notified that any
> disclosure, copying, distribution or taking any action in reliance
> of the contents of this information is strictly prohibited and may be
> unlawful. KPMG is neither liable for the proper and complete
> transmission of the information contained in this communication nor
> for
> any delay in its receipt.
> ======================================================================
> ==========