Re: select time

a- thanks for the code, using it

On Jun 14, 2006, at 10:47 AM, John Siracusa wrote:
> That's kind of an odd thing to want :)  Can't you get your local time
> and adjust it to the time zone of the db, if necessary?

b - not really for 2 reasons - one normal, the other odd
         clustering: time should be based on the db writing app which  
does all the logging.  if webapp and db are on different machines,  
things can get messy. running ntp solves it kind of, but only when  
machines are freshly synced.
         integrity: i'm doing some integrity stores that basically  
store md5( item , time ) + time.  i want to use the same time in the  
md5 and the time save field.  its hard to explain, but getting a time  
out of the db that is valid  ( not a future time in case of drift )  
and recycling through the transaction works well




| - - - - - - - - - - - - - - - - - - - -
| RoadSound.com / Indie-Rock.net
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - -