CODEWITHSUNDEEP
sqlitedate-format
Harish
Harish

Reputation: 55

How to change date format in sqlite database

How do I change the format of a date in %d/%m/%Y or any other from this string 10/09/2016 in sqlite?

I have tried this but it is not working:

select strftime('%d/%m/%Y', '09-10-2016'),t_date from party_trans

Upvotes: 2

Views: 22427

Answers (3)

Hitesh Save
Hitesh Save

Reputation: 1

Store date into INTEGER type in database.

select strftime('%d/%m/%Y', date) from table

Upvotes: 0

blkerai
blkerai

Reputation: 341

try this query

select strftime('%d/%m/%Y',datetime(substr(t_date, 7, 4) || '-' || substr(t_date, 4, 2) || '-' || substr(t_date, 1, 2))) from party_trans;

Upvotes: 4

Nishant Kumar
Nishant Kumar

Reputation: 2179

I would suggest to store date as time stamp instead of string. Timestamp gives you more flexibility and accuracy than date. Convert your date into millisecond (timestamp) format and store it into your database as INTEGER type.

Or try this:

select strftime('%d/%m/%Y', '2016-10-09');

Upvotes: 2

Related Questions