Hi,
I my name is ryan and I own a small site which has a mysql database and servlet
support.
I have a simple query to all you mysql gurus...
my table is very simple, i created a table with the following
create table datee(int today);
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()));
the reason why I am doing this is coz I need to get the current date into my java app
and this is not working
....
Statement statement;
Resultset rs=statement.executeQuery("select DAYOFMONTH(sysdate())");
if(rs.next())
{rs.getString(sysdate());}
.......
does anyone know how to get the current date,month from the database into your java
program?
Please reply to [EMAIL PROTECTED] as I am unable to get into the mysql list.
Any help appreciated.
-Ryan.
NOTE TO MySql admins
--------------------
Why in the world am I not able to get into the MySql list?
my email is [EMAIL PROTECTED] and everytime I subscribe I get an error telling me that
this is a perminant error and that its given up on it.
Kindly help or manually include me into the list please.
---------------------------------------------------------------------
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
