Fetching date from databse

[tushar attar]

Hi
I want to fetch data from my sql database. Knowing that sql store date in yyyy-mm-dd format, I want to fetch this date in form of day, month and year separately in java (may be in form of string, three different variables).

How can I do that? Please tell

Thanks

[Jeanne Boyarsky]

Tushar,
JDBC allows you to get the date from the database in the form of a Date object. Then you can use SimpleDateFormat in Java to parse it.

[Dave Tolls]

tushar attar wrote:Knowing that sql store date in yyyy-mm-dd format ...

Not so.
That's simply the default display format for whatever database workbench or tool you happen to be using.
Different databases store Dates in different ways.

[Campbell Ritchie]

Your SQL query probaby allows you to create an instance of this Date class. You might do well to create a LocalDate object (Java8 only) and use its methods to get day month or year. More details in the Java™ Tutorials; try the Date Classes section.

Sorry for delay in replying; I wrote this post hours ago and forgot to push submit.

[grace christopher]

tushar attar wrote:Hi
I want to fetch data from my sql database. Knowing that sql store date in yyyy-mm-dd format, I want to fetch this date in form of day, month and year separately in java (may be in form of string, three different variables).

How can I do that? Please tell

Thanks

In particular, it means you don't need to worry about the time zone of the Calendar vs the time zone of a SimpleDateFormat - you can just parse to a LocalDate, which is what the data really shows you. It also means you don't need to worry about months being 0-based

import java.util.*;
import org.joda.time.*;
import org.joda.time.format.*;

public class Test {

    public static void main(String[] args) throws Exception {
        DateTimeFormatter formatter = DateTimeFormat.forPattern("dd/MM/yyyy")
            .withLocale(Locale.UK);

        LocalDate date = formatter.parseLocalDate("18/08/2012");

        System.out.println(date.getYear());  // 2012
        System.out.println(date.getMonthOfYear()); // 8
        System.out.println(date.getDayOfMonth());   // 18
    }
}

[Knute Snortum]

Hi grace, and Welcome to the Ranch!  Thanks for your contribution.  Just one thing, if you could UseCodeTags (that's a link) when you post code, it will be easier to read and reference lines.  Thanks.