[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
> now,what statement do I use to put the sysdate into the column today?
> this is NOT working
> insert into datee values(select DAYOFMONTH(sysdate()));
Of course not. "insert into datee values (Now())" will, though. Just feed it
to mysql ... ;)
Here's the JavaScript euqivalent, if that helps:
function GetTheDate()
{
now = new Date;
ty = now.getYear();
if(ty < 1900)
{
ty = ty + 1900;
}
mo = now.getMonth();
mo = mo + 1;
return(ty+'-'+ShowZeroFilled(mo)+'-'+ShowZeroFilled(now.getD
ate())+'
'+ShowZeroFilled(now.getHours())+':'+ShowZeroFilled(now.getMinutes()));
}
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 -
http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
