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.<div>
<br></div><div>The odbc stuff from squirrelmonkey just gives you the textual representation of whatever you ask for. There is no native type binding. </div><div><br></div><div>If the Date() datatype takes a constructor then pull the date from the database in an appropriate format.</div>
<div><br></div><div>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.<br><br><div class="gmail_quote">On Tue, Jun 15, 2010 at 4:37 PM, David Swardstrom <span dir="ltr"><<a href="mailto:dswardstrom@remotelink.com">dswardstrom@remotelink.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">I am working with Javascript and Freeswitch to emulate some Conferencing<br>
capability that the company I am working for has in production using<br>
other products.<br>
<br>
One thing that I need to do is to access a timestamp from a database in JS.<br>
In pgAdmin for Postgres this is a "timestamp without time zone".<br>
<br>
In JS there is a data type called Date.<br>
<br>
Question: If I read a row of the database which includes this timestamp<br>
field, what should I put it into?<br>
* Can I put it directly into a Date data type?<br>
* Does it have to come out as a string or a number?<br>
* If it is a number can I then put it into a Date?<br>
* If it is a string, what is the format:<br>
Is it: "YYYY-MM-DD HH:MM:SS.ffffff"?<br>
<br>
I looked in mod_spidermonkey_odbc.c pdbc_next_row() and it appears to<br>
call SQLFetch() and return the result.<br>
But information on a row contains both a value but it's type,<br>
so what will the interpreter do?<br>
<br>
If anyone knows, let me know, otherwise I will incorporate a way<br>
to test this into my code and let everyone know (may also add this<br>
to some Wiki).<br>
<br>
Regards,<br>
David Swardstrom<br>
(profile)<a href="http://wiki.freeswitch.org/wiki/User:Dswardstrom" target="_blank">http://wiki.freeswitch.org/wiki/User:Dswardstrom</a><br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>-Rupa<br>
</div>