Hello,
I have year, mounth, day, minutes, secundes as Integer. How can I make timestamp value from integers. I want to do it inside trigger.
Thanks for your help. Dusan
I have tryed :
CREATE TRIGGER GSM_IN_INSERT FOR GSM_IN AFTER INSERT EXECUTE
(
VAR
MTHOUR INTEGER;
MTMIN INTEGER;
MTSEC INTEGER;
MDYEAR INTEGER;
MDMONTH INTEGER;
MDDAY INTEGER;
MTSTAMP TIMESTAMP;
...
MTSTAMP = TIMESTAMP (MAKEDATE (MDYEAR, MDDAY), MAKETIME (MTHOUR, MTMIN, MTSEC));
...
)
but this is not correct, because MAKEDATE (year, day) needs day of year.
I don't have day of year but day of month and month.
How can I solve it? Help me please.
Dusan
-- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
