If you're using 9i, there's a timestamp datatype. Not supported in 8i, of
course. So, you'd have to do a work around. Whether you store phony dates to
go with your time, or store your time in a varchar2 column depends on what
you want to do with your time. I'd _guess_ that if you don't have a date
relevant to the time, then you're not going to be treating it as a _real_
time (i.e. not doing time math and stuff like that). In which case, I'd
probably store it as a varchar2.
-d
----- Original Message -----
From: "Daniel Kessler"
> I have to record a time in a DB. It would seem that I'd do that with
> createTime. I have just a few simple questions.
> In the Oracle DB, do I make a date field as usual and populate it
> with yr/mo/da = 0,0,0 and then insert the createTime variable in one
> block? Is there maybe a time type for a field? (I suppose not).
> IOW, how is just time, where no date is needed, handled?
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- the time Daniel Kessler
- Re: the time Deanna Schneider
- Re: the time daniel kessler
- Re: the time Janet Schmitt
- Re: the time daniel kessler