>>>>> "PJ" == Paul Jakma <paulj at itg.ie> writes:
PJ> if i do:
PJ> select foo from bar where dongle=999;
PJ> and foo is of type DATE, i get:
PJ> 18-MAR-01
PJ> my question is? does a DATE type store the time of day too,
PJ> and if so, how do i get it to print it?
Philip Greenspun covers Orcale's date gar (and lots of other stuff)
in:
http://philip.greenspun.com/wtr/oracle-tips.html
It's near the top, in the section "Dating and Oracle".
--
"Pity has no place at my table."
-- Dr Hannibal Lecter
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
