[thesite] timezones

Daniel J. Cody djc at starkmedia.com
Mon Aug 27 09:23:08 CDT 2001


rudy, i notice the following line in the query that does grabs comments:

to_char(replies.datemod, 'mm/dd/yyyy HH:mi:ss') datemod,

is it that we're turning the date into a character string there? just 
wondering if this might have somethnig to do with it, because in the DB, 
matt's comment does have a timestamp of 4:40:39 PM yesterday

thanks for the heads up matt, and ya you can shorten the urls by 
replacing the title of the article with whatever you want:

http://www.evolt.org/article/foo/18/15126/index.html#comment15187

.djc.

Matthew Haughey wrote:
> I noticed a comment I made today is showing up as being posted at 4:40AM 
> this morning, when I actually popped in sometime around 3PM pacific 
> today. I don't see any timezones in my prefs, is the machine time off?
> 
> http://www.evolt.org/article/Using_Apache_to_stop_bad_robots/18/15126/index.html#comment15187 
> 
> 
> Matt
> (btw, is there a < 80 char shortcut for evolt URLs so I can safely send 
> them via email without breaks?)






More information about the thesite mailing list