Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Dates coming up as 0000-00-00 even when date format changed

Quote Reply
Dates coming up as 0000-00-00 even when date format changed
Hi-

I looked for a solution to my problem in the forum, but I didn't find anything so I'm posting a new message. Here goes :) ::

I've imported my dbman flatfile db to dbmanSQL and all the dates are coming up as 0000-00-00. The format I used in dbman is MMM-DD-YYYY. So inorder for both formats to match I changed the Date.pm so that the format is MMM-DD-YYYY. However, this didn't help. What else do I need to change so that the date doesn't come up as all zeros? Unsure

Thanks!
Reena
Subject Author Views Date
Thread Dates coming up as 0000-00-00 even when date format changed Reena0330 2902 Aug 8, 2002, 1:59 PM
Thread Re: [Reena0330] date 0000-00-00
Reena0330 2825 Aug 13, 2002, 1:13 PM
Thread Re: [Reena0330] date 0000-00-00
604 2824 Aug 13, 2002, 3:35 PM
Thread Re: [TheStone] date 0000-00-00
Reena0330 2801 Aug 13, 2002, 3:46 PM
Thread Re: [Reena0330] date 0000-00-00
604 2815 Aug 13, 2002, 3:50 PM
Post Re: [TheStone] date 0000-00-00
Reena0330 2780 Aug 15, 2002, 12:58 PM