Re: Put a date in a mysql



"robsonarduin@xxxxxxxxx" <robsonarduin@xxxxxxxxx> writes:
i have a JFormattedTextField with the MaskFormatter ##/##/####
(dd/MM/yyyy) and i want to put this data into a mysql table. But i
don´t know how. Any suggestions for me ?

Use a SimpleDateFormat parse to convert to a java.util.Date,
wrap that as a java.sql.Date and use PreparedStatement setDate.

Arne
.



Relevant Pages

  • Re: installed mysql/php/apache but theres no mysql.sock file
    ... My email client is set to wrap lines at 72 chars. ... > mysql.sock is a UNIX socket, ... > adequate permissions to create the socket. ... In eterm I do the same command and it returns the pid ...
    (freebsd-questions)
  • Re: Date field in DD/MM/YYY
    ... Bart Van der Donck wrote: ... when that is written to MySql it is either not accepted or ... another value is tored in the database. ...
    (comp.lang.javascript)
  • Re: Date field in DD/MM/YYY
    ... Jes wrote: ... when that is written to MySql it is either not accepted or ... another value is tored in the database. ...
    (comp.lang.javascript)
  • Re: Date field in DD/MM/YYY
    ... another value is tored in the database. ... I had put it in YYYYMMDD because that was the request of the original ... Obviously, MySQL will accept much ...
    (comp.lang.javascript)
  • Re: Date field in DD/MM/YYY
    ... when that is written to MySql it is either not accepted or ... another value is tored in the database. ... as accepted correctly in sql. ...
    (comp.lang.javascript)