Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

Re: Default to current date

Nov 21, 2000, 6:14 AM
santana
User (86 posts)
Nov 21, 2000, 6:14 AM
Views: 5634
Shortcut
Quote Reply
Re: Default to current date In reply to
In Reply To:
Most likely because the existing dates in your flat-file don't conform to the mySQL DATE format which is YYYY-MM-DD
Well, i have changed the format to yyyy-mmm-dd (it was reformated by excel, and saved as txt)
but when I import it into mySQL, they just changed to 0s.
But, When I changed the field in mySQL into TEXT before the import, then it shows correctly.

I tried to changed the field in mySQL to 'DATE' then it shows 0s again.

thanks for replying :)


__________________________
SantanaBlank
Subject Author Views Date
Thread Default to current date Bearwithme 5822 Oct 14, 2000, 2:49 PM
Thread Re: Default to current date 		Bearwithme 5688 Oct 15, 2000, 6:42 AM
Post Re: Default to current date 		Stealth 5706 Oct 16, 2000, 8:25 PM
Thread Re: Default to current date 		donm 5649 Oct 28, 2000, 3:34 AM
Thread Re: Default to current date 		Bearwithme 5653 Oct 28, 2000, 3:41 AM
Thread Re: Default to current date 		santana 5621 Nov 21, 2000, 12:15 AM
Thread Re: Default to current date 		Bearwithme 5616 Nov 21, 2000, 3:56 AM
Thread Re: Default to current date 		santana 5634 Nov 21, 2000, 6:14 AM
Thread Re: Default to current date 		Bearwithme 5602 Nov 21, 2000, 8:19 AM
Post Re: Default to current date 		santana 5601 Nov 21, 2000, 9:34 PM