welcome 123
asked on
SYSBASE IQ how to filter the table rows thru the TIMSTAMP column value.
Example:
Table has two columns
Create table temp1
col name varchar 20,
DATE_EFF_TO timestamp 8
;
I want fileter 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
WHERE to_date(DATE_EFF_FROM)=201 3/06/07'
can you please give me the correct query to fetch only those rows whose value for June 7th 2013.
Thanks in advance.
Table has two columns
Create table temp1
col name varchar 20,
DATE_EFF_TO timestamp 8
;
I want fileter 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
WHERE to_date(DATE_EFF_FROM)=201
can you please give me the correct query to fetch only those rows whose value for June 7th 2013.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Afraid I don't - sorry.
Sybase is very similar to SQL Server, & you may find more sql server resources than Sybase.
(but there are differences, like timestamp)
Sybase is very similar to SQL Server, & you may find more sql server resources than Sybase.
(but there are differences, like timestamp)
ASKER