ok, not sure why you are getting that value out of the database. It
should come back in date format unless you are casting it as an
integer. Within your SQL statement you can use the TO_DATE() function
to reset the format.
Is this the value returned within a query, or a seperate value from a
stored procedure?
-Adam
On 11/7/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> I'm not sure I follow what you are trying to do....
>
> -Adam
>
> On 11/7/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> > Date/time is represented as the number of seconds passed since... well
> > I can't remember. I want to say 1/1/1970. But I'm not very sure.
> >
> > -Adam
> >
> > That begs the question, "How does one easily convert this to a
> > formatted time value?"
>
> I am trying to take the value I get from the database ("19122019") and turn
> it into something like 18:13 or 6:13 pm for display.
>
>
> --------------
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> Confidentiality Notice: This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223504
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
