[Freeswitch-users] Javascript Database Timestamp and Date()

[Rupa Schomaker]

Postgres has lots of date manipulation functions.  So, you should be able to
use them to get/set the timestamp to a format that is suitable for whatever
you are doing in JS.  Look at the date/time functions in the postgres
manual.

The odbc stuff from squirrelmonkey just gives you the textual representation
of whatever you ask for.  There is no native type binding.

If the Date() datatype takes a constructor then pull the date from the
database in an appropriate format.

For setting date from a JS Date() you'll want to see what format Date() can
give you and look at the timestamp casting / construction possibilities.

On Tue, Jun 15, 2010 at 4:37 PM, David Swardstrom <
dswardstrom at remotelink.com> wrote:

> I am working with Javascript and Freeswitch to emulate some Conferencing
> capability that the company I am working for has in production using
> other products.
>
> One thing that I need to do is to access a timestamp from a database in JS.
> In pgAdmin for Postgres this is a "timestamp without time zone".
>
> In JS there is a data type called Date.
>
> Question: If I read a row of the database which includes this timestamp
> field, what should I put it into?
> * Can I put it directly into a Date data type?
> * Does it have to come out as a string or a number?
> * If it is a number can I then put it into a Date?
> * If it is a string, what is the format:
>  Is it: "YYYY-MM-DD HH:MM:SS.ffffff"?
>
> I looked in mod_spidermonkey_odbc.c pdbc_next_row() and it appears to
> call SQLFetch() and return the result.
> But information on a row contains both a value but it's type,
> so what will the interpreter do?
>
> If anyone knows, let me know, otherwise I will incorporate a way
> to test this into my code and let everyone know (may also add this
> to some Wiki).
>
> Regards,
> David Swardstrom
> (profile)http://wiki.freeswitch.org/wiki/User:Dswardstrom
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>



-- 
-Rupa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100615/fec8d846/attachment.html