List:General Discussion« Previous MessageNext Message »
From:Stephen Johnston Date:October 1 1999 9:37pm
Subject:RE: Date routines
View as plain text  
At 11:30 AM 10/1/99 , you wrote:
>On Fri, 1 Oct 1999, Stephen Johnston wrote:
>
> > That's the strange thing, I get nothing... if I use the proper YYYY-MM-DD
> > 00:00:00 syntax. I didn't create that table, do you think the previous
> > developer is storing a timestamp in a string field or something?
> >
>
>What does 'DESCRIBE user' tell you?
>
>--
>Bob Kline
>mailto:bkline@stripped
>http://www.rksystems.com

Bob-

         I figured it out. The knucklehead who made the table made the 
setupdate field a varchar(100). I knew I inherited this job from some 
boobs, but come on!!! I assumed there had to be something wrong, not that 
someone had done something stupid like that. Sheeesh.

-Stephen Johnston
Thread
Date routinesStephen Johnston1 Oct
  • Re: Date routinesMartin Ramsch1 Oct
  • RE: Date routinesbkline1 Oct
    • RE: Date routinesStephen Johnston1 Oct
      • RE: Date routinesBob Kline1 Oct
        • RE: Date routinesStephen Johnston2 Oct