Page 1 of 1

Problem inserting date

Posted: Sun Jan 25, 2009 12:35 pm
by xionhack
Hello, I have a query, and when I run it the date is never inserted. What is the problem? The field where that date is inserted is a "date" type. Can somebody tell me what is the problem? Thanks!

Code: Select all

 
INSERT INTO activity (type_activity, details, date, member_id)
VALUES (1, 'activity', '1/1/2009', 1)
 

Re: Problem inserting date

Posted: Sun Jan 25, 2009 12:46 pm
by califdon
The default format for a 'date' type field is like '2009-01-01'.

Re: Problem inserting date

Posted: Sun Jan 25, 2009 12:47 pm
by xionhack
Thanks for your quick response. Is there a way for it to insert it independently of how you write it? Something like a conversion function or something like that

Re: Problem inserting date

Posted: Sun Jan 25, 2009 12:58 pm
by califdon