Table has two columns
Create table temp1
col name varchar 20,
DATE_EFF_TO timestamp 8
I want filter records and fetch only those records whose timestamp has date June 7th 2013.
I gave the following query but it didn't fetch any records for this date:
SELECT * FROM temp1
can you please give me the correct query to fetch only those rows whose value for June 7th 2013.
using Sybase but looks like any sql using sqlserver works in Sybase right?
Thanks in advance.