Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Pedido_Insert_Delete
Pivot the Hard Way.
SQL - Social Network Analysis by Patrick Lin
PostreSQL: Today's Date/Time
Assignment 1(SET A)
Atuação
Pedido
SQL hierarchical query. branch of responses.
Ecommerce Website Analysis by SQL
Leetcode 569. Median Employee Salary
Please log in to post a comment.