Kurt, Thanks for your message.
>>date() returns NULL because you're giving it an illegal time string Well, I thought the date (not the time) string I'm giving is correct, e.g. "2004/1/3'. It is in the correct format "YYYY/MM/DD". I am not interested in the DATE part, that is why I'm calling "date()" function instead of "datetime()". Regards Eugene *********** REPLY SEPARATOR *********** On 01/03/2004 at 5:12 PM Kurt Welgehausen wrote: >There seem to be some problems with the date/time functions, >but your statements will never work. Your select returns >NULL because date() returns NULL. date() returns NULL >because you're giving it an illegal time string. Read the >docs again, and pay attention to the list of legal time >strings. > >Regards > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]