Hi
I've only just started to use postgreSQL and i'm a bit confused by the timestamp thing. In MySQL, when i set the data type to timestamp, everything i create a new record a timestamp is automatically inserted.
in pgsql, i get prompted with leaving the timestamp field null. how can i get postgreSQL to automatically insert the timestamp in without me explicitly calling a date and formating before inserting.
Also, the timestamp format is different, and it has a +8 at appended to it, which is the timezone. how can i change it to my localtime without the +8?
Thanks
I've only just started to use postgreSQL and i'm a bit confused by the timestamp thing. In MySQL, when i set the data type to timestamp, everything i create a new record a timestamp is automatically inserted.
in pgsql, i get prompted with leaving the timestamp field null. how can i get postgreSQL to automatically insert the timestamp in without me explicitly calling a date and formating before inserting.
Also, the timestamp format is different, and it has a +8 at appended to it, which is the timezone. how can i change it to my localtime without the +8?
Thanks