... == "" ? NULL(DT_DATE) : (DT_DATE)This_Date
-- if data source column is of datatype string and european date format: return SQL date
(TRIM(This_Date) == "") ? (DT_DATE)"1900-01-01" : (DT_DATE)(SUBSTRING(This_Date,1,2) ...
... = ''; -- 1900-01-01
SET @TimeVal = ''; -- 00:00:00.000
SET @DateMatch = 0;
SET @TimeMatch = 0;
SET @ColumnTypeIsDate = 0;
-- Determine if Given Value is date
...
... 1900-01-01
SET @TimeVal = ''; -- 00:00:00.000
SET @DateMatch = 0;
SET @TimeMatch = 0;
SET @ColumnTypeIsDate = 0;
-- Determine if Given Value is date
...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.