How to separate month day year in saving into database

Question

Hello I'm working on my system and I'm stuck right now on how to save separably the month day and year to a separate column .. In my system I have an objective that let user print report month or daily basis , and my solution is to save the day month and year to a each separate columns.. Is this posible ? Sorry for my bad english .

Answer 1

For example, you can take system date as String, as it can be seen from this resource: How to convert current date into string in java?

ZoneId zoneId = ZoneId.of( "America/Montreal" ) ;  // Or ZoneOffset.UTC or ZoneId.systemDefault()
LocalDate today = LocalDate.now( zoneId ) ;
String output = today.toString() ;

Later you can use split to divide string for needed values (Year, month of day), for example, like here: How to split a String by space

str = "2017-05-03";
String[] splited = str.split("-");

In the last example instead "-", maybe, you need to use ASCII code of "-". Alas, I forget this

Answer 2

You can use the LocalDate from JDK 8 Date-Time API as below to get year, month and day and persist them in DB:

LocalDate date = LocalDate.now(); 
int year = date.getYear();
int month = date.getMonthValue(); // or Month month = date.getMonth() if you want month names
int day = date.getDayOfMonth();

Answer 3

The other Answers are correct about using LocalDate in Java.

Database

As for the database, define your column as a date-only type such as the SQL Standard‘s type DATE.

JDBC

If your JDBC driver complies with JDBC 4.2, you can use the java.time types such as LocalDate directly.

myPreparedStmt.setObject( … , myLocalDate ) ;

And:

LocalDate ld = myResultSet.getObject( … , LocalDate.class ) ;

If your driver does not comply, fall back to using the java.sql types. You may convert to-and-fro by calling new methods added to the old classes. But use the java.sql types as briefly as possible, doing all the real work with java.time classes.

myPreparedStmt.setDate( … , java.sql.Date.valueOf( myLocalDate ) ) ;

…and…

LocalDate ld = myResultSet.getDate( … ).toLocalDate() ;