What you are seeing in sqlplus is the string representation of the date.
All the dates have time. Try:
select to_char(my_date_field,'mm/dd/yyyy hh24:mi:ss') from mytable...
And you will see the time part. It is there.
Your English is understandable.
Jim
"Peter Valicek" <sonny_at_valicek.net> wrote in message
news:b0vf7t$e2$04$1_at_news.t-online.com...
> Hallo NG,
>
> just a little quetsion about datatype date.
>
> We had an 8.1.7 Database. In alle fields where in my opinion should be as
> well an time value only the date is in like 23-jan-03. I have checked
> nearby all tables but nowhere is the time givven. But in our applikation
is
> time very essential so it have to be there. In my eyes it does it not make
> much sence to split date and time in seperate fileds.
>
> Exist an command or an special select ( like extend in informix ) do
extend
> the field, if it's as well in the field but not obvisuely seen?
>
> Or let me say it other.
> Is the time value as well in the date field but hidden? If yes hot to get
> it? if no has anyone an idea?
>
> Pls. Help.
>
> Regards
>
> -Peter
>
> P.S: Excuse my worse english. I'm not very trained in stuff like this.
> --
> [ Linux is like a Wigwam - no Windows, no Gates, Apache inside ]
Received on Sat Jan 25 2003 - 20:14:17 CST
