Remove time zone and precision from PostgreSQL query results

Remove time zone and precision from PostgreSQL query results

I have been using PostgreSQL functions to piece together. Today I suddenly found that it can be so simple, just use timestamp (0) to solve it:

1. Ls => select createtime: timestamp (0) without time zone from users;
   
2. Createtime
3. ---------------------
4. 2015-10-03 01:32:03
5. 2015-10-03 01:32:03
6. 2015-10-03 01:32:03
7. (3 rows of Records)
8. Ls => select createtime: timestamp without time zone from users;
9. Createtime
10. ----------------------------
11. 2015-10-03 01:32:03. 080415
12. 2015-10-03 01:32:03. 080415
13. 2015-10-03 01:32:03. 080415
14. (3 rows of Records)

------------------------------------ Lili split line ------------------------------------

Install the PostgreSQL 9.3.5 database in Ubuntu Server 14.04

Install PostgreSQL 6.3 on yum in CentOS 9.3

PostgreSQL cache details

Compiling PostgreSQL on Windows

Configuration and installation of LAPP (Linux + Apache + PostgreSQL + PHP) Environment in Ubuntu

Install and configure phppgAdmin on Ubuntu

Install PostgreSQL9.3 on CentOS

Configure a Streaming Replication cluster in PostgreSQL

How to install PostgreSQL 7/6 and phpPgAdmin in CentOS 5/6. 4

------------------------------------ Lili split line ------------------------------------

PostgreSQL details: click here
PostgreSQL: click here

This article permanently updates the link address: