On Thu, 2006-01-05 at 10:04, Tadej Kanizar wrote:
> Hi!
>
>
>
> I’ve got a timestamp field.. and it returns sth like “2006-01-04
> 21:33:17.156”. How can I get the same result, just without the .156?
> I’ve looked at date/time formatting functions, etc, but couldn’t find
> a straight way to do this L
Here ya go:
test=> create table t1 (ts timestamp);
CREATE TABLE
test=> insert into t1 values (now());
INSERT 2106750874 1
test=> select ts from t1;
ts
----------------------------
2006-01-05 10:15:48.167951
(1 row)
test=> select cast (ts as timestamp(0)) from t1;
ts
---------------------
2006-01-05 10:15:48
(1 row)
test=> select ts::timestamp(0) from t1;
ts
---------------------
2006-01-05 10:15:48
(1 row)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
