forum

Home / DeveloperSection / Forums / FInd current data from table in sql server?

FInd current data from table in sql server?

Anonymous User179716-May-2013

Hi Guys!

I have a table, in this table every record insert with current data time column.

My line of code as following

CREATE TABLE tblOrder

(

Order_ID INT IDENTITY PRIMARY KEY,

Order_Code INT,

Order_Date Date

)

INSERT INTO tblOrder(Order_Code,Order_Date) VALUES (542,GETDATE())

INSERT INTO tblOrder(Order_Code,Order_Date) VALUES (152,GETDATE())

INSERT INTO tblOrder(Order_Code,Order_Date) VALUES (122,GETDATE())

INSERT INTO tblOrder(Order_Code,Order_Date) VALUES (243,GETDATE())

INSERT INTO tblOrder(Order_Code,Order_Date) VALUES (102,GETDATE())

SELECT * FROM tblOrder WHERE Order_Date = GETDATE()

My problem is that above select query not return record.

Please help.

Thanks in advance.

Updated on 16-May-2013

I am a content writter !

Can you answer this question?

Answer

16-May-2013

Hi Lois!

Try as following

SELECT * FROM tblOrder WHERE Order_Date = (CAST (getdate() as date))

I hope it helpful to you.