Extract date from timestamp

priyan

hi

I am having a startdate variable with timestamp datatype. I want to extract only the date from timestamp field........

Expand|Select|Wrap|Line Numbers

select extract('hour' from timestamp '2001-02-16 20:38:40')

this query extracts hour from the input in the same way is there any option for extracting only date.

Please help as soon as possible.

michaelb

Try this:

Expand|Select|Wrap|Line Numbers

 
postgres=# SELECT date ('2001-02-16 20:38:40');

    date

------------

 2001-02-16

(1 row)
 
postgres=# SELECT '2001-02-16 20:38:40'::date;

    date

------------

 2001-02-16

(1 row)

priyan

Quote:

Originally Posted by michaelb

Try this:

Expand|Select|Wrap|Line Numbers

 
postgres=# SELECT date ('2001-02-16 20:38:40');

    date

------------

 2001-02-16

(1 row)
 
postgres=# SELECT '2001-02-16 20:38:40'::date;

    date

------------

 2001-02-16

(1 row)

thank you for helping me

Extract date from timestamp

re: Extract date from timestamp

re: Extract date from timestamp

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/other

/bytes/about