Typecast sql.date to calendar

Question

I have some code that uses the sql.date object to get the current date in the format: yyyy-MM-dd. I want to typecast that to a Calendar object that has the same format as the sql.date.

Here is the code for the sql.date:

java.util.Date now = new java.util.Date();

java.sql.Date sqlDate = new java.sql.Date( now.getTime() );

Edit:

I want to know how to put this in a Calendar object. Is it even possible to do this?

[The standard library does not support a formatted Date-Time object.](https://stackoverflow.com/a/68009408/10819573) — Arvind Kumar Avinash, Jul 11 '21 at 17:41

score 3 · Accepted Answer · answered Aug 02 '13 at 13:27

A java.sql.Date doesn't have a format. It's just a date.

To convert it to a string, use a SimpleDateFormatter with the relevant format set - or just use toString if you definitely want yyyy-MM-dd. (Unfortunately it's unclear which time zone you should use - java.sql.Date is very poorly documented in this respect. I suspect it will use the default system time zone.)

To create a Calendar object with the given date, you can just use:

Calendar calendar = Calendar.getInstance();
calendar.setTime(sqlDate);

Again, a Calendar doesn't have a text format either - it represents a point in time in a particular calendar system in a particular time zone, but nothing about a textual representation.

This worked thank you. I did not understand how date formats and dates worked. — jacen.garriss, Aug 02 '13 at 13:52

Bohemian · Answer 2 · 2013-08-02T13:33:57.637

Java Date objects (and note that java.sql.Date is a java.util.Date) don't have "formats". They represent an instant in time.

Calendar also doesn't have a "format".

What you're asking for doesn't make sense in java.

Consider using SimpleDateFormat to format one of these things into a String:

String str = new SimpleDateFormat("yyyy-MM-dd").format(myDate);

or if you use a Calendar object (not recommended):

String str = new SimpleDateFormat("yyyy-MM-dd").format(myCalendar.getTime());

score 1 · Answer 3 · answered Aug 02 '13 at 13:30

1

Use SimpleDateFormat#format()

System.out.println(new SimpleDateFormat("yyyy-MM-dd")
                   .format(Calendar.getInstance().getTime()));

answered Aug 02 '13 at 13:30

Ravi K Thapliyal

51,095
9
76
89

So I should just replace the Date with the Calendar completely? – jacen.garriss Aug 02 '13 at 13:30
Yes, no need to construct `java.util.Date` separately. You'd get it from `Calendar#getTime()`. – Ravi K Thapliyal Aug 02 '13 at 13:32

score 0 · Answer 4 · answered Aug 02 '13 at 13:45

You can use the following snippet.

public class DateTest {

public static void main(String[] arg){

    Calendar calendar = Calendar.getInstance();
    //setting a valid date
    Date date = new Date(113,07,10);
    //prints the date as per format
    System.out.println("Date in YYYY-MM-DD : " +date);
    //sets the calendar with the date value in java.sql.Date instance
    calendar.setTime(date);
    //use simple date formatter to format the value in calendar instance
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
    System.out.println("Date formatted from Calendar instance : "+dateFormat.format(calendar.getTime()));
}

}

Please let me know what happens!

Typecast sql.date to calendar

4 Answers4