can java.sql.Date in different Date pattern ?

[Nakata kokuyo]

hi, good day, i just wan to ask whether we can have java.sql.Date in date pattern like 12/25/2005 rather just 2005-12-25 ? thank you

[Jeff Albertson]

java.sql.Date like its superclass java.util.Date is basically a long timestamp: it's about the value, not the formatting. If you want to produce string representation of a date formatted in a certain way, use SimpleDateFormat.

[Jesper de Jong]

Date objects (whether it's java.util.Date or java.sql.Date) do not have a format. When you convert a Date object to a string by calling toString() on it, the date is formatted with a certain default format.

If you want to have your Date object formatted differently, use java.text.SimpleDateFormat to format it. Because java.sql.Date is a subclass of java.util.Date, you can pass java.sql.Date to the SimpleDateFormatter without converting anything. Example:

java.sql.Date date = ...; // you got it from the database somehow
DateFormat df = new SimpleDateFormat("dd/MM/yyyy");
String text = df.format(date);
System.out.println("The date is: " + text);