Re: [GENERAL] date format problem

2000-05-03 Thread Anand Raman
helps Anand Raman - Original Message - From: Bill Barnes <[EMAIL PROTECTED]> To: Anand Raman <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 03, 2000 1:51 PM Subject: RE: [GENERAL] date format problem > Hello Anand: > > Thanks for the input. >

RE: [GENERAL] date format problem

2000-05-03 Thread Lincoln Yeoh
I dunno, I'm using 6.5.3 and have no probs pgdumping, pguploading and using null dates - moved my app to another server etc, and the null dates are still there. The null dates are dumped as \N which presumably means NULL (but for some reason typing \N (two characters - backslash then N) works for

RE: [GENERAL] date format problem

2000-05-03 Thread Bill Barnes
Hello Anand: Thanks for the input. The problem turned out to be date fields with null values. Disappointing! A lot of my Sybase procedures tested for null dates. So my workaround was to edit the null dates to a pseudo date. This is least got my database poplulated. Will try the cast for que

Re: [GENERAL] date format problem

2000-05-02 Thread Anand Raman
HI bill Try to cast the field to the datetime type 'ur_string_goes_here'::datetime Hope this will help Anand Raman - Original Message - From: Bill Barnes <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 28, 2000 6:09 PM Subject: [GENERAL] date format problem > Hello Li