Re: How is date storeed in column?
Date: 2000/06/29
Message-ID: <IhJ65.166$Hs3.3811_at_news1.mts.net>#1/1
[Quoted] Matt, Thanks a bunch for your help......but where do I check (or set) that value? Sorry, I'm new to this whole database stuff. All help greatly appreciated, thanks!
"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message
news:sll8gth8jev147_at_corp.supernews.com...
> "Beginner" <NOSPAM_at_hotmail.com> wrote in message
> news:vpt65.27$Hs3.1402_at_news1.mts.net...
> > When a field is declared as a 'date' type, what format is it? Can it be
> > stored as 'dd-mon-yy hh:mm:ss am'?
> > I have a date field that says too many precision specifiers when I
truncate
> > it this way...Do I have to store this as a string?
>
> Your date format is defined by the NLS_DATE parameter. Check that setting
and
> modify as needed. However it affects all users of your database so be
careful.
>
> BTW, in regards to: 'dd-mon-yy hh:mm:ss am',
> I think you really want 'dd-mon-yy hh:mi:ss am'. (Use of 'mm' instead of
'mi'
> for minutes will cause the 2-digit month to appear there, NOT minutes -
easy
> mistake - done it myself hundreds of times.)
>
> -Matt
>
>
Received on Thu Jun 29 2000 - 00:00:00 CEST