Search code examples
sqlderby

Syntaxerror: Encountered "<EOF>" at line 1, column 16

I'm trying to learn SQL via SQL tutorials on Youtube and none of the commands/functions are working for me.

I am experiencing a syntax error:

Encountered "<EOF>" at line 1, column 16.

select getdate()
           ^

1 statement failed.

I have tried with and without ";" but always getting the same result.

SELECT GETDATE();

I would've expected to see the current date but it doesn't work. I'm pretty sure its something super simple but I just can't see it.

Solution

  • Instead of "dual", in IBM lingo, I believe the dummy table is called SYSIBM.SYSDUMMY1.

    Try this:

    select current_date from sysibm.sysdummy1