Re: [SQL] timestamps over the web - suggestions

2006-10-06 Thread Bruno Wolff III
On Tue, Oct 03, 2006 at 14:44:12 -0700, chester c young <[EMAIL PROTECTED]> wrote: > My server is based MST, but web clients from Maine to Hawaii, and they wish > to see timestamps based in their own locale. > > Can anyone tell me how they're handling this? (sorry - can't get rid of my > clie

Re: [SQL] timestamps over the web - suggestions

2006-10-03 Thread ljb
[EMAIL PROTECTED] wrote: > > My server is based MST, but web clients from Maine to Hawaii, and they wish > to see timestamps based in their own locale. > > Can anyone tell me how they're handling this? (sorry - can't get rid of my > clients) Here's a bit of JavaScript that might work for you. I

Re: [SQL] timestamps over the web - suggestions

2006-10-03 Thread Aaron Bono
You should probably handle this at the application level.  How you go about it will depend on what programming language you use.If you don't like that, check out the timezone function: http://www.postgresql.org/docs/8.0/static/runtime-config.html#GUC-TIMEZONESee also for an example:http://www.varle

[SQL] timestamps over the web - suggestions

2006-10-03 Thread chester c young
My server is based MST, but web clients from Maine to Hawaii, and they wish to see timestamps based in their own locale.Can anyone tell me how they're handling this?  (sorry - can't get rid of my clients) Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail.