Select query Based On Date And Time

[hcclSmokey]

Hi There

I am trying to find out how to write a select query based on the current date and current time. The query needs to return a result from a column, phone number, in my table based on the current date and time. My record is quite simple;

Date Time Phone Number
24/06/2004 12:00:00 555-1234

Any help would be greatly appreciated.

Regards
Smokey

 

[SQLBill]

I'm only showing the pertinant part of the code, but try this:

WHERE [Date] = CONVERT(CHAR(10), GETDATE(), 103)
  AND [Time] = SUBSTRING(CONVERT(CHAR(20), GETDATE(), 120), 12, 8)

-SQLBill