Save date time in Database in format other than GMT

Certified Lead Developer

Hi All

I have a very curious question that I want to save the date and time in the database in GMT+4:00 and not GMT. Is there any way/configuration it can be done ?

 

I am very well aware of retrieving and converting the dates to and fro from db and showing in other formats but my requirement is to save the dates in other format.

 

Also, I will be saving the dates at the time of process running (using now() function) or something like that.

 

If not possible then do I need to make that configuration on DB server-side only?

 

Thanks

Arpit

  Discussion posts and replies are publicly visible