Re: date field - default value = current date

2002-09-18 Thread Paul DuBois
At 1:32 -0700 9/18/02, neal wrote: >Is there a wat to have mySQL auto fill in the current date into my >dateCreated field? > >In SQLServer I would simply specify the getDate() method as a default value. >I presume I would use the analogous MySQL function curDate() but it does not >appear to work f

re: date field - default value = current date

2002-09-18 Thread Egor Egorov
neal, Wednesday, September 18, 2002, 11:32:39 AM, you wrote: n> Is there a wat to have mySQL auto fill in the current date into my n> dateCreated field? n> In SQLServer I would simply specify the getDate() method as a default value. n> I presume I would use the analogous MySQL function curDate()

Re: date field - default value = current date

2002-09-18 Thread Mikhail Entaltsev
Check TIMESTAMP type in the documentation. Best regards, Mikhail. - Original Message - From: "neal" <[EMAIL PROTECTED]> To: "mySQL" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 10:32 AM Subject: date field - default value = current date >

date field - default value = current date

2002-09-18 Thread neal
Is there a wat to have mySQL auto fill in the current date into my dateCreated field? In SQLServer I would simply specify the getDate() method as a default value. I presume I would use the analogous MySQL function curDate() but it does not appear to work for me. Any suggestions? -