get distinct persian month from timestamp in mysql

Question

I need to get distinct persian month from the timestamp field in mysql table. this is my query:

select distinct month(startTime) from times where subset_id='$subset_id' ORDER BY `id` DESC

but it returns a distinct Gregorian year and I can`t use it... how can I solve this?

MySQL only supports Gregorian calendar. Everything else needs to be custom coded. [This](https://sourceforge.net/projects/mysqlpersiandat/) shows up in my search engine. — Álvaro González, Nov 30 '19 at 09:07
Your code is vulnerable to SQL injection. You should use prepared statements. — Dharman, Nov 30 '19 at 09:22

score -1 · Answer 1 · answered Nov 30 '19 at 09:25

-1

in case of timestamp you will get month from this line

DATE_FORMAT(FROM_UNIXTIME(startTime), '%m')

finally your query is

select 
    distinct DATE_FORMAT(FROM_UNIXTIME(startTime), '%m')
from times where subset_id='$subset_id' ORDER BY `id` DESC

answered Nov 30 '19 at 09:25

1 Answers1