Author |
Topic |
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-10-05 : 12:19:21
|
Dear All,I am converting Cognos Queries into SQL Query.Can anybody tell me the equvalent SQL query for below Cognos query.select date= (CDATE(T1."SERVICE_DATE_IH")) from T1 Thanks,Gangadhar |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-10-05 : 12:29:11
|
Dear All,Also this part of the Query Select xyz=((YMDINT_EXTRACT(DATETIME_TO_YMDINT((CDATETIME(LASTDAY(CDATE(T1."INVOICE_CREATE_PERIOD_DT_IH"))))),4))) from T1 pls help me in this regard.Thanks,Gangadhar |
|
|
X002548
Not Just a Number
15586 Posts |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-10-05 : 12:31:08
|
Cdate() actually a Cognos Function. The query is generated by Cognos i am migrating it to SQL.Pls help |
|
|
X002548
Not Just a Number
15586 Posts |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-10-05 : 12:40:37
|
I am not sure with Cdate() function in Cognos ? :( |
|
|
X002548
Not Just a Number
15586 Posts |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-05 : 14:28:54
|
cdate() in vb converts the expression to date format. so i think equivalent sql statement should be convert(datetime,...) or cast(... as datetime) |
|
|
X002548
Not Just a Number
15586 Posts |
|
|