MYSQL including a function in a string

Question

I'm trying to create a trigger which returns the current date. But I'm struggling to include Curdate() function in a string

 DELIMITER $$ 
create trigger invalid_date 
    before insert on invoice 
    for each row 
begin 
    if new.date_in <> CURDATE() then 
        signal sqlstate '45000' set message_text = 
            "TriggerError: The date_in date should be Curdate()" ;
        end if ;
end$$ 
DELIMITER;

Doing it this way won't return the current date but rather just treat Curdate() as a string. My question is how do I include the Curdate() into the error message and actually return a date.

Have you tried CONCAT?

lukas.j
– lukas.j

2021-10-25 16:36:58 +00:00
Commented Oct 25, 2021 at 16:36 — lukas.j
– lukas.j, Commented Oct 25, 2021 at 16:36

vivekpadia70 · Accepted Answer · 2021-10-25 16:37:13Z

1

You can use CONCAT function to print date.

message_text = CONCAT("Your string: ", CURDATE())

answered Oct 25, 2021 at 16:37

vivekpadia70

1,1253 gold badges13 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MYSQL including a function in a string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related