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: 5622
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 5811 Oct 14, 2000, 2:49 PM
Thread Re: Default to current date 		Bearwithme 5677 Oct 15, 2000, 6:42 AM
Post Re: Default to current date 		Stealth 5695 Oct 16, 2000, 8:25 PM
Thread Re: Default to current date 		donm 5638 Oct 28, 2000, 3:34 AM
Thread Re: Default to current date 		Bearwithme 5642 Oct 28, 2000, 3:41 AM
Thread Re: Default to current date 		santana 5610 Nov 21, 2000, 12:15 AM
Thread Re: Default to current date 		Bearwithme 5605 Nov 21, 2000, 3:56 AM
Thread Re: Default to current date 		santana 5622 Nov 21, 2000, 6:14 AM
Thread Re: Default to current date 		Bearwithme 5591 Nov 21, 2000, 8:19 AM
Post Re: Default to current date 		santana 5590 Nov 21, 2000, 9:34 PM