SQL: how to query a column named "Sysdate"

Question

Hello,

I have a column named Sysdate in several tables, which is causing SQL errors when I try to Select it. It works if "Sysdate" is enclosed in double-quotes, e.g.

SELECT "Sysdate" FROM table1

When I try to use aliases it causes syntax errors:

SELECT t1."Sysdate" FROM table1 AS t1

Please advise.

Thank you,

Max.

Answer 1

For what database? MySQL allows you to escape reserved keywords using backticks:

SELECT `sysdate` FROM TABLE1

In SQL Server, you use hard brackets:

SELECT [sysdate] FROM TABLE1

Oracle uses double quotes:

SELECT "sysdate" FROM TABLE1

Answer 2

try this for sql server

SELECT [Sysdate] FROM table1

for MySQl this should work, those are back ticks btw

SELECT `Sysdate` FROM table1

Answer 3

Try:

SELECT [Sysdate] FROM table1;