CSP Query

[dandcg]

Hi,

I was wondering how to make a CSP query return report information based on SI_STARTIME....

SELECT SI_NAME, SI_ID, SI_PROGID,
SI_STARTTIME, SI_ENDTIME, SI_NEXTRUNTIME, SI_PARENTID,
SI_SCHEDULE_STATUS, SI_RECURRING, SI_OWNER, SI_ERROR_MESSAGE FROM CI_INFOOBJECTS WHERE
SI_INSTANCE = 1

I have tried the following additions and the don't work.

AND SI_STARTTIME>DATETIME(2004,11,18,0,0,0)
AND SI_STARTTIME>'18/11/2004 00:00:00'

The below would work in SQL.....

Can abody help...

Dan

 

[pelajhia]

oddly enough this allows me to either pull all records:
si_starttime > 12345672910
or no records:
si_starttime > 12345673910
(1000 greater)

so I am figuring this is some fancy numerical representation of the date; it may depend on your database as to how exactly such a figure is calculated. You are on sql server?
Someone with dba skills may be able to explain this.

 

[jrennatc]

I've been successful with 'yyyy.mm.dd'