time stamp trouble with linux postgres installation

2012-04-08 Thread Gonzo Rock
Hey guys gals... Happy Easter Fertility Rights Spring Celebrations to all... as you can see I'm working :-( A client recently updated his linux box and now I've got an issue that is puzzling me. I'm using cfset RightNow = Now() #RightNow# I'm getting the correct time displayed on the

Re: time stamp trouble with linux postgres installation

2012-04-08 Thread Paul Hastings
On 4/9/2012 2:40 AM, Gonzo Rock wrote: Then using cfset theDate = CreateODBCDateTime(RightNow) the value returned from now() should be ok to insert into DB, no need for this step. Going through all the time and time zone settings on the linux box all seems right. db cf on same server?