Re: [SQL] Date problem

2000-10-07 Thread Edipo E. F. Melo
On Fri, 29 Sep 2000 09:58:27 -0400, Tom Lane wrote: Returning from previous thread, i found a solution for my problem: "when everything fails, read the manual..." Reading the OS/2 command reference, it says that TZ has three parts: XXXCYYY. XXX - is the timezone name, C is the inc

Re: [SQL] Date problem

2000-09-28 Thread Tom Lane
>> Ok. Let's work. I posted a mail before explaining a strange >> cituation if my Postgresql: when I use date_part() function to split >> day, month and year of a date type column, it returns one day before. >> In other words, '2000-01-01' returns day: 31, month:12, year: 1999. > No problem here.

Re: [SQL] Date problem

2000-09-28 Thread Josh Berkus
Elipo, > Ok. Let's work. I posted a mail before explaining a strange > cituation if my Postgresql: when I use date_part() function to split > day, month and year of a date type column, it returns one day before. > In other words, '2000-01-01' returns day: 31, month:12, year: 1999.

[SQL] Date problem

2000-09-28 Thread Edipo E. F. Melo
Hi all, Hi all, Before all, a little (off-topic) comment: >It's been my experience that Win32 ODBC does not drop >connections until the database client is closed (e.g. MS >Access is shut down). "There is some things that only Micro$oft can do for you..." Ok. Let's wor