| Excerpt |
|---|
SQL for the ETL+ Extract SQL Statement Panel required for data accessed with the ETL+ Source Driver for Text Files (.CSV). |
...
Expression | Results |
SELECT Now() AS Expr1 FROM ProductSales GROUP BY Now(); | Returns the current system "Date and Time" in the default system Time format and displays in the column Expr1. |
SELECT Now() AS CurrentDateandTime FROM ProductSales GROUP BY Now(); | Returns the current system "Date and Time" in the default system Time format and displays in the column CurrentDateandTime. |
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 | |
Related Pages
...