Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Convert date from long time postgres

Tags:

sql

time

postgresql

How do I select the date as a readable string from epoch time in milliseconds?

Some like: SELECT *, to_date(time_in_milli_sec) FROM mytable

like image 406
Nirmal- thInk beYond Avatar asked Oct 24 '11 08:10

Nirmal- thInk beYond

People also ask

How do I convert datetime to date in PostgreSQL?

The TO_DATE function in PostgreSQL is used to converting strings into dates. Its syntax is TO_DATE(text, text) and the return type is date. The TO_TIMESTAMP function converts string data into timestamps with timezone. Its syntax is to_timestamp(text, text) .

How do I change the date format in PostgreSQL?

You can change the format in the postgresql. conf file. The date/time styles can be selected by the user using the SET datestyle command, the DateStyle parameter in the postgresql. conf configuration file, or the PGDATESTYLE environment variable on the server or client.

1 Answers

Per PostgreSQL docs:

SELECT *, to_timestamp(time_in_milli_sec / 1000) FROM mytable
like image 124
Yahia Avatar answered Sep 24 '22 00:09

Yahia
Sign in to Comment

Related questions

SQL: Select dynamic column name based on variable
SQL query in Spark/scala Size exceeds Integer.MAX_VALUE
Select average from MySQL table with LIMIT
Compare Columns Where One is Similar to Part of Another
Query several NEXTVAL from sequence in one statement
MySQL get mindate and maxdate in one query
Using a view with no primary key with Entity
SQLite - how to get average value?
Can I use a MySQL database with an App Engine application
How do I edit a table in order to enable CASCADE DELETE?
T-SQL Insert into table without having to specify every column
Does SQLite3 not support foreign key constraints?
MS Sql: Conditional ORDER BY ASC/DESC Question
how to see generated sql from a linq query
Database structure for "customer" table having many orders per customer and many items per order
Where did Open Table go in SQL Server 2008?
Core Data Performance with Single Parent Entity
'CREATE VIEW' must be the first statement in a query batch
How to select using WITH RECURSIVE clause [closed]
How do I select a column using an alias

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!