Sybase date time

scorpion · Post by **scorpion** » Thu Aug 30, 2007 3:23 am

Hi All,

I am using Sybase as my source database tables and datasets are my target files.

In one of my sybase table column like'DTTM' and the value for this column like:

'Dec 31 3999 12:00AM'
'Jan 23 2015 09:00 AM'
'Feb 28 2010 10:00 AM'
'Dec 31 3999 12:00AM'

But i need to extract records where DTTTM = 'Dec 31 3999 12:00AM'

How can i mention in user defined sql in sybase source stage?

is it exactly like:

where DTTTM = 'Dec 31 3999 12:00AM'

or do i need to conver to some thing?

could any one on help me?

ray.wurlod · Post by **ray.wurlod** » Thu Aug 30, 2007 5:14 am

How would you do it usng Sybase Open Client - that is if DataStage were not in the picture?

scorpion · Post by **scorpion** » Thu Aug 30, 2007 6:33 am

Thanks for the reply Ray,

I tried to run the qry like below using my SQLAdvantage tool in my sybase database:

where DTTTM = 'Dec 31 3999 12:00AM'

but i am wondering will this work on datastage?

any suggestions--

chulett · Post by **chulett** » Thu Aug 30, 2007 7:25 am

Did it work? There's nothing magic or different about DataStage, a query is still a query. If you can make it work there, it will work here.