sql server query current date from database

Question

I want to find few data from SQL Server that only query by current date. The purpose is to view today transaction only

Here is my code

SELECT * FROM dbo.Student.studentProfile
WHERE TransactionDate = curdate()

RESULT

Curdate is not a recongined built-in function name

@Juken: The accepted answer for this question includes `CURRENT_TIMESTAMP`. So does the accepted answer for the duplicated question. — C-Pound Guru, Jun 12 '15 at 12:43

score 4 · Accepted Answer · answered Jun 12 '15 at 01:16

4

If you are looking for the current date:

WHERE TransactionDate = cast(getdate() as date)

Or if you prefer ANSI standards:

WHERE TransactionDate = cast(CURRENT_TIMESTAMP as date)

answered Jun 12 '15 at 01:16

Gordon Linoff

1,242,037
58
646
786

TQ very much. both code works for me. – MUHD MAN Jun 12 '15 at 01:24

score 2 · Answer 2 · answered Jun 12 '15 at 01:17

Different sql implementations (ie SQL Server, Mysql, postgresql etc) can have different methods supported. For SQL Server the method you want to use is GETDATE() instead of CURDATE()

The documentation for this method is here: https://msdn.microsoft.com/en-us/library/ms188383.aspx

score 0 · Answer 3 · answered Jun 12 '15 at 01:15

0

Try this.

select * from dbo.Student.studentProfile
    WHERE TransactionDate >= dateadd(day,datediff(day,1,GETDATE()),0)
        AND TransactionDate < dateadd(day,datediff(day,0,GETDATE()),0)

answered Jun 12 '15 at 01:15

aadarshsg

2,069
16
25

TQ for response. I already try the code you given. No error and no output, meanwhile have today date in my table. – MUHD MAN Jun 12 '15 at 01:20

sql server query current date from database

3 Answers3