reset password
Author Message
bseemscs
Posts: 26
Posted 20:52 Aug 15, 2015 |

I and my computer are on Honolulu time but when I run the script to populate the csjobs database with current_timestamp for a date field postgresql is entering Pacific time. Why is postgresql stuck in Los Angeles?

bseemscs
Posts: 26
Posted 21:31 Aug 15, 2015 |

I tried using localtimestamp as well but still seeing the date field populated with Pacific time.

cysun
Posts: 2935
Posted 08:57 Aug 16, 2015 |

You can use the "show timezone" command to see which timezone PostgreSQL is using.

You can change the time zone in the configuration file postgresql.conf under the data folder of the PostgreSQL folder.