Excerpt |
---|
SQL for the ETL+ Extract SQL Statement Panel required for data accessed with the ETL+ Source Driver for Text Files (.CSV). |
...
SQL Syntax for Text (.CSV) Data Sources
Date()
See https://support.microsoft.com/en-us/office/date-function-dd7a1f27-d957-4969-ab35-01e0bfbfed76
...
Returns the current date and time according your computer's system date and time. https://support.microsoft.com/en-us/office/now-function-671467d4-aed0-4a78-b533-b7b87a533b5a
Expression | Results |
| Returns the current system "Date and Time" in the default system Time format and displays in the column Expr1. |
| Returns the current system "Date and Time" in the default system Time format and displays in the column CurrentDateandTime. |
DATEADD()
DATEADD("d",-7,DATE()) as [last-week]
Miscellaneous
SQL Expression | Compatibility Text File Source Driver | |
---|---|---|
123 AS <name> | OK | |
CAST | No | |
GETDATE() | No | |
NULL AS <name> | 1️⃣ Problem with T-SQL Expression on Design page during load. | |
DATE() | Current system date in short date format: "dd/mm/yyyy". | |
DATEADD() | Yes | |
NOW() | Yes | |
...
External
...