5 messages in com.mysql.lists.win32Re: Java syntax for importing dates i...| From | Sent On | Attachments |
|---|---|---|
| Januski, Ken | 24 Jan 2002 19:31 | |
| Aaron West | 25 Jan 2002 09:35 | |
| Januski, Ken | 25 Jan 2002 13:10 | |
| webm...@w3space.com | 25 Jan 2002 17:10 | |
| Januski, Ken | 28 Jan 2002 14:22 |
| Subject: | Re: Java syntax for importing dates into mySql |
|---|---|
| From: | Aaron West (aaro...@healthstream.com) |
| Date: | 01/25/2002 09:35:21 AM |
| List: | com.mysql.lists.win32 |
If the date column in your MySQL database is specified as a datetime, you can specify the field as "NOW()" in your INSERT statement. This will format the date correctly and insert the current MySQL server date and time into your field.
| Aaron S. West | Associate Instructional Technologist
----- Original Message ----- From: "Januski, Ken" <kjan...@phillynews.com> To: <win...@lists.mysql.com> Sent: Thursday, January 24, 2002 9:31 PM Subject: Java syntax for importing dates into mySql
| Hi, | | I'm fairly new to Java and am trying to find the best method to format a | current date to import into a date field in mySQL. I've done it in Perl but | now am working in Java. I'm sure this is a common problem so am wondering if | anyone has any ideas. I've been searching the mailing list archives but have | found nothing so far. | | Thanks, | | Ken Januski | | | | --------------------------------------------------------------------- | Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before | posting. To request this thread, e-mail win3...@lists.mysql.com | | To unsubscribe, send a message to the address shown in the | List-Unsubscribe header of this message. If you cannot see it, | e-mail win3...@lists.mysql.com instead. | |