that would go into a string typically by default, it may be possible to select the date field as epoch time depending on the databse type which is a long int that you could feed to time formatting options of your own.<div>
<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>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:+19193869900<br>
</div>