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