On Wed, 2008-12-10 at 21:07 -0800, www.t24all.com wrote:
> Hi All,
>
> I have a DATE value as "2007-11-30 10:30:19" I want to convert this
> value to Unix Time Stamp as "1196440219"
>
> In MySQL query i used to do SELECT UNIX_TIMESTAMP('2007-11-30
> 10:30:19');
>
> I want to do the same in jBASE. Any in-built functions or any
> formulas to derive?
There may well be something in the ICONV() function that does that, but
I don't find it documented (make sure you search the jBASE Web Site),
however, do you really mean the UNIX timestamp, or do you mean the
internal time of jBASE (which for historical reasons is not the same).
Internal to external form is well supported by ICONV and OCONV.
But, do you mean in jBASE SQL?
Please take a few minutes to read the posting guidelines and provide
details about the version of jBASE, how you are accessing it, and so on.
It greatly helps to get your question answered. Unanswered question are
generally unanswered because there is not enough information.
Jim
>
> Your help is greatly appreciated.
>
> Thanks In Advance
>
> >
--~--~---------~--~----~------------~-------~--~----~
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
-~----------~----~----~----~------~----~------~--~---
