Postgresql: get week from date
Trabla:
Postgresql: get week from date
Solving:
1.
From date
select
date_part
(
'week'
, date '2015-02-16')
result: 8
2.
From Timestamp
select
date_part
(
'week'
, timestamp '2015-02-16 20:38:40')
result: 8
No comments:
Post a Comment
Newer Post
Older Post
Home
No comments:
Post a Comment