Re: timestamp weirdness with WO and FrontBase
Re: timestamp weirdness with WO and FrontBase
- Subject: Re: timestamp weirdness with WO and FrontBase
- From: Chuck Hill <email@hidden>
- Date: Thu, 31 Jan 2008 18:14:34 -0800
On Jan 31, 2008, at 3:36 PM, Kevin Windham wrote:
I have an app that stores a start date for an event. When entering
a date in the web app it appears fine. In the DB it shows up as a
day earlier because it looks like the timestamp in the db is offset
backwards by several hours.
Is this related to timezone, or frontbase, or something else? I
don't really want to have the data modified since the date and time
are specific to a locale already. It just confuses things to have
any kind of timezone or offset applied.
The reason I even bring this up is that it seems for some reason
across restarts the dates in the web app get the actual db date and
not what was originally entered into on the html form.
A) Make sure the FrontBase column is TimeStamp NOT TimeStamp with
Time Zone
B) What Ray said.
Chuck
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden