Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
UNIX_TIMESTAMP
--PostgreSQL 9.6 --'\\' is a delimiter -- FUNCTION: winactor.update_limits(character varying) -- DROP FUNCTION winactor.update_limits(character varying); CREATE OR REPLACE FUNCTION update_limits(vdate character varying) RETURNS void LANGUAGE 'plpgsql' COST 100 VOLATILE AS $BODY$ DECLARE vUnixTimestamp BIGINT; vdateStamp varchar(250); BEGIN raise notice 'Value: %', vdate; vdateStamp:=''''||vdate||''''; raise notice 'Value: %', vdateStamp; SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE vdateStamp) INTO vUnixTimestamp; raise notice 'Value: %', vUnixTimestamp; UPDATE limitsbackup2020 set death_time = vUnixTimestamp where secret_phrase is null and name=''; raise notice 'Value: %', vUnixTimestamp; END; $BODY$; ALTER FUNCTION winactor.update_limits(character varying) OWNER TO postgres;
run
|
edit
|
history
|
help
0
test
Pivot the Hard Way..
postgresql select test
Sush_post1
stackoverflow example for 47702144
SQL Moving Rating Practice by Han Wang 20200720
FINALE fdjfnkds
Query for matching substring from text field in DB
asd
How i can get the difference of closest two date in two table join in postgresql