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
univesp
jsonb handle
PostreSQL: product table
Many to many
stackoverflow example for 47702144
2
3
Food Delivery Website SQL Analysis
Joins and Case
Movie Rating SQL Analysis Project