PostgreSQL-Learning/date.sql at main · Hazrat-Ali9/PostgreSQL-Learning · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30


-- SHOW timezone;
SELECT now();

create table timeZ (ts TIMESTAMP without time zone , tsz TIMESTAMP with time zone );

INSERT into timez VALUES('2024-01-12 10:45:00', '2024-01-12 10:45:00');

SELECT * from timez;


SELECT now();

SELECT CURRENT_DATE;

SELECT now()::date;
SELECT now()::time;

SELECT to_char(now(), 'DDD');

SELECT CURRENT_DATE - INTERVAL '1 year 2 month';

SELECT age(CURRENT_DATE, '1995-07-29');

SELECT *, age(CURRENT_DATE, dob) from students;

SELECT extract(month from  '2024-01-25'::date);

SELECT 'n'::BOOLEAN;