Page 1 of 1

Date(Fabruary-14-2003)!

Posted: Thu Mar 02, 2006 4:59 am
by heerajee
Hi,
I have got tired while finding out the way to input the date into the database inthe form of "Fabruary-14-2003".
while using three lists to select date(list for year,list for month,list for days), then concatinate them in one variable. While inserting into the database i got error (Unknown column 'February' in 'filed list').
Is there any solution to store the date in this format like "Fabruary-14-2003", if you know, please inform me.


After concatinating the three lists in one variable, the variable shows the value like this(Fabruary-14-2003) but is not stored into the database.



Thanks.
Asif Arif

Posted: Thu Mar 02, 2006 10:45 am
by alex.barylski
Here is my solution...

Don't use preformatted dates...use a timstamp and convert it to the date format you want at run time.

Date problem.

Posted: Fri Mar 03, 2006 11:24 pm
by heerajee
Assalamo Aliekum,

I am very thankfurl for your consideration, i want to know tha how can i enter this date(Fabruary-14-2003) with the help timestamp into the database.

Thanks in advance.
Asif Arif