I've had issues with time in AS3 <-> SQL Server before. I can't remember the exact solution but essentially what it boils down to is that the following two times are actually the same:
2-5-1985 00:00:00 2-4-1985 24:00:00 There could be some conversion going on between the way your AS3 treats the number and how the database treats it. You might try setting the datetime to 2-5-1985 00:00:01 to force all systems to interpret it the same way. -Cameron On Fri, Aug 7, 2009 at 11:58 AM, Dale Bronk <[email protected]> wrote: > This may be a dumb question, but I'm stuck so I need to ask. I'm have a > tough time with dates. A customer in California enters a DOB of 2/5/1985 > and saves (AMF app using Granite) which goes into the db with actual data > of > 2-5-1985 00:00:00. Now a customer in Georgia opens the same record and the > DOB is 2/4/1985. I understand that the timezones on the clients are > different. I'm looking for any advice on solving this without storing as > text. > > Thanks, > Dale > > > > ------------------------------------------------------------- > To unsubscribe from this list, simply email the list with unsubscribe in > the subject line > > For more info, see http://www.affug.com > Archive @ http://www.mail-archive.com/discussion%40affug.com/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [email protected]
