Miggins wrote:
> Hi,
>
> Thanks but i am aware of that. I didnt explain fully what I wanted. We
> have DATETIME fields on Forms which have a format mask of DD-MON-YYYY.
>
> When storing these fields Forms appends 00:00:00 to the end of the
> date. So am wanting to strip these times off as it passes back to the
> DB server. Can this be done in one place, IE the App Server or will we
> have to do it on every DATETIME field on every form.
>
> TIA
>
Every DATE field has a time component. Unless you try to mess up
a design by storing your date as a string, I would suggest you don't
bother, and use the appropriate format mask.
Just select to_char(date_field,'YYYY-MM-DD') if you do not want the time
component.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Nov 02 2005 - 12:26:36 CST
