Can we make a column name as current_Date value like below ? And these column names are not fixed, they change every month. Any suggestion is greatly appreciated.
I am using Teradata version 14.10.
You can give columns the names that you suggest (not sure it's a good idea, but you can do it).
If an object name does not follow standard SQL naming conventions then you must include it in double quotes (speech marks) every time you reference it.
So the following is valid SQL:
CREATE TABLE t1
And then to read from the table you'd have to use something like:
WHERE "1/3/2018" > 57;
If your column names are dynamic then you'll have to generate the SQL at run-time, using a stored procedure or scripting code.