Home
Kimball Group Home
Search
Register
Log indate object.
Page 1 of 1
date object.
Afaf Tue Sep 18, 2012 9:45 pm
need to create an objet at universe level that will be restricted to fetch yesterday 7:00 am to today 7:00 am.
The field name is dateLoaded, which is a datetime, and displays Date time in list of values.
DB is sql 2008.
Plz help me......
The field name is dateLoaded, which is a datetime, and displays Date time in list of values.
DB is sql 2008.
Plz help me......
Afaf- Posts : 14
Join date : 2012-09-18
Re: date object.
Afaf Wed Sep 19, 2012 8:14 pm
after trying all... i got this working superbly fine...
"InspectionSheet.DateLoaded between
DATEADD(dd,-1,CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(), 120) + '
07:00:00',120)) and
CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(), 120) + ' 07:00:00',120)"
"InspectionSheet.DateLoaded between
DATEADD(dd,-1,CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(), 120) + '
07:00:00',120)) and
CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(), 120) + ' 07:00:00',120)"
Afaf- Posts : 14
Join date : 2012-09-18
Similar topics» SCD object in SSIS
» Flag object to differentiate the Cust IDs coming from 2 different data providers
» Date Dimension: Representing partial dates/Imputing date values
» 3 objects in the query that is causing the measure object to multiple. By 2
» Initial date of effective date column for SCD 2 implementation
» Flag object to differentiate the Cust IDs coming from 2 different data providers
» Date Dimension: Representing partial dates/Imputing date values
» 3 objects in the query that is causing the measure object to multiple. By 2
» Initial date of effective date column for SCD 2 implementation
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum