Excel date automatically converted into number this number again convert in Java date

Question

I have some data in Excel and I have to import in the database using Java but my date is automatically converted into a number but I have to save it as a date.

Search Stack Overflow before posting. If not yet covered, post details. Link to documentation. Give examples of inputs and outputs. — Basil Bourque, Aug 20 '18 at 15:40
@BasilBourque i had already searched on stack overflow but i din't get proper answer so if you know kindly provide me solution for it. — Devraj verma, Aug 21 '18 at 05:20

score 1 · Accepted Answer · answered Aug 20 '18 at 14:10

1

So the date that you are getting in java is essentially long timeInMillis, just convert that long value to date, refer Convert millisecond String to Date in Java

answered Aug 20 '18 at 14:10

Niranjan Kumar

1,348
11
27

No actually got date in just 5 digit. – Devraj verma Aug 20 '18 at 14:11
2

provide snippet that and the output as well – Niranjan Kumar Aug 20 '18 at 14:14

Excel date automatically converted into number this number again convert in Java date

1 Answers1