Getdate() function does not work in SQL Server 2014 Express

Question

I am a newbie to programming. I downloaded the free version of SQL Server 2014, the Express edition. Somehow the Getdate() function is not working. It says

Incorrect syntax near '('.

If I just say GETDATE. It says

Could not find stored procedure 'GETDATE'.

Can someone tell me if some library is missing from my installation?

I tried reinstalling the software assuming that some libraries were missing.

getdate() is what I am trying. Even the Datepart() and any of the date functions does not work.

Could you please help me to resolve the above issues and guide on the correct syntax?

`SELECT GETDATE()` - function call or `DECLARE @v DATETIME = GETDATE()` — Lukasz Szozda, Jun 18 '19 at 18:25
You should consider deleting this question. Since it is just typo it is not going to help anybody in the future. — Sean Lange, Jun 18 '19 at 18:47

M. Kanarkowski · Answer 1 · 2019-06-18T19:30:39.833

1

To do it work you need to add select.

SELECT GETDATE()

edited Jun 18 '19 at 19:30

answered Jun 18 '19 at 18:25

M. Kanarkowski

2,155
8
14

Oh I am an idiot! Thanks for your lightning fast reply. – Sharath Chandra Jun 18 '19 at 18:27

Rafael Lima · Answer 2 · 2019-06-18T18:36:31.790

1

GETDATE() is a function, you need to close the parentheses and add SELECT clause.

Type SELECT GETDATE();

And check the oficial docs: GETDATE (Transact-SQL)

edited Jun 18 '19 at 18:36

answered Jun 18 '19 at 18:29

Rafael Lima

420
1
5
16

Getdate() function does not work in SQL Server 2014 Express

2 Answers2