File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes MySQL Date field , how to assign current date as default value ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL Date field , how to assign current date as default value ?" Watch "MySQL Date field , how to assign current date as default value ?" New topic
Author

MySQL Date field , how to assign current date as default value ?

raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
Hi
Thank you for reading my post
i want to ask how i can assign current date as a default value of a filed when i create the table ?
i am using mysql.

thanks
karthikeyan Chockalingam
Ranch Hand

Joined: Sep 06, 2003
Posts: 259
Hope this helps you



You may use insert stmt like and
created_dt column is assigned the current date time ...Is it what you want?


http://www.skillassert.com


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL Date field , how to assign current date as default value ?