I do get the same warning too but it does produce a valid date/datetime value which I had no problems with loading into Oracle and SQL Server date/datetime columns.
The code you listed and the warning message do not match. I bet you use the $start_time somewhere else as well, e.g. a print and there the warning comes from.
Yeah, yeah, yeah, I get it. First it is useful error messages, next you will be asking for debugging and at the end you will require useful documentation of the scripting language. I get it…
What I would actually would love to do is changing the entire scripting language to JavaScript. Can be compiled, fast, standard, I am sure there are editors out there,… Anyway nothing we will have time for within the next 100 years.
Hmmm we already have debugging although no in-line step debugging for functions and the Reference Guide is probably the best piece of documentation I’ve ever seen for ANY ETL tool.
I’m fine with the language as it stands now - although I would really like to have support for Array datatypes and the ability to do a REVERSE Index on a string. (e.g. Start at point 72 and then find the position of the first X character on the LEFT of that point). I’ll add these to the improvements topic.
Hi,
I want to use date with time, how do you write this?
$TodayDate=To_date(to_char(sysdate(), ‘YYYY-MM-DD’) || ‘00:00:00’, ‘YYYY-MM-DD HH:mm:ss’);
Thank you