Date auto changing - no clue how

Hello,

id_expiry_date - varchar(50)

sample data arabic date (yyyy/mm/dd)
1436/03/7
1436/06/22
1435/02/08
1436/04/14

after some random days above data become dd/mm/yyyy automatically.

i do not do any db update at all. but this date format changes at randam interval.

so i wonder how come this happen?

:rolleyes:

Check all SQL UPDATE queries that interact with that column in that table. Something, somewhere, is changing the format, and UPDATE is the only thing that I can think of that would do that.

EDIT: Re-read what you wrote. If you’re not doing ANY update queries… then… hmmm… is there any kind of automated/scheduled process that accesses that table?

HTH,

Oh, got the culprit, there was one old script which had date inverse code which is the one who responsible for this.
any way, that is an stand alone script, how the heck itself auto executing ?

Thanks wolfi…

Without being able to see your setup, I couldn’t even begin to think about what caused it to execute. Glad you figured it out! :slight_smile: