<input value="mapa Lublin" id="mapa" onClick="this.select()">
28 lip 2010
<input value="mapa Lublin" id="mapa" onClick="this.select()">
SELECT t_add_date,
SUBSTRING(t_add_date :: CHARACTER varying, 1, 19)
FROM TABLE
WHERE t_add_date & lt;
NOW() - '1 DAY' :: interval t_add_date SUBSTRING
2010-03-10 21:26:49.928445 2010-03-10 21:26:49
2010-03-10 21:26:49.928445 2010-03-10 21:26:49
SELECT
ROUND(liczba, 2) AS liczba1,
ROUND(liczba, 4) AS liczba2
FROM tabela
select * from table where t_add_date < NOW()-'5 MONTH'::interval
select * from table where t_add_date < NOW()+'5 MONTH'::interval
select * from table where t_add_date < NOW()-'1 DAY'::interval
select * from table where t_add_date < NOW()-'2 DAYS'::interval
select * from table where t_add_date < NOW()-'1 DAY'::interval
select * from table where t_add_date < NOW()-'5 MINUTES'::interval
select * from table where t_add_date < NOW()-'3 HOURS'::interval
select SUBSTRING(schemat,'^(.+),') from tabela_schematy
Dane:
public,data
Wynik:
public