Re: How is date storeed in column?

Thanks, everyone.....I got everything figured out that I needed. I noticed that whenever I selected a date that was entered into a table it returned only dd-mon-yy, but it actually stored it with all the precision figures. I was initially led to believe that it only stored those values, but after your help, and viewing the data in dba studio, I found that it stores everything I need.

    Thanks!

--
Joseph Ranseth - Webmaster
World Cup Fishing
Phone:(204) 944-8945 Fax: (204) 943-0954
http://www.worldcupfishing.com
"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message
news:slo6r1tijev47_at_corp.supernews.com...


> "Beginner" <NOSPAM_at_hotmail.com> wrote in message

> news:OlJ65.167$Hs3.3966_at_news1.mts.net...

> > Randy, thanks for your help...

> > What I need to know though, is how can I retrieve the time value of a

 date


> > entered into the database?

> > ie: A user makes an entry, I want to track the time it was placed.

> > Currently it's entering SYSDATE in that field, but when I do a select,

 it


> > shows only DD-MON-YY.  Does it store the time as well?  IF so, how can I

> > retrieve it, if not, how can I do so?

> > Thanks!

>

> to_char(<date value>,<format mask>)

>

> example:

>

> select to_char(sysdate,'MM/DD/YYYY HH24:MI:SS) from dual;

>

> The format mask is pretty versatile - about anything you can dream up

 (within


> reason) can be put there.

>

> Get a copy of "Oracle 8 The Complete Reference" - it's about the best

 "overall"


> guide to Oracle SQL and the Oracle database.  Find it on amazon.com or

> bookpool.com (bookpool is usually a little cheaper).

>

> -Matt

>

>