Hi, I'm using "select * from calendar where datum >= current_date ORDER BY datum ASC" in my code to show every event listed in my database where the date = or is greater than today's date. I have a field (datum) in my table, with the type date (2006-02-23). The browser is showing this great in Europe, but in the US he is not showing the event of today. Does anybody know why he is not showing events from the current date in the US, and how I can solve this ? Thank You for your help. Peter
How to you evaluate the "today's date" ? In GMT ? Adjusting or not the the local time of people ?
When it's 08h00 the 23/II/2006 in the morning in Brussels, it can be 23h00 in Los Angeles, so the day before, the 22/II/2006.