date object.

View previous topic View next topic Go down

date object.

Post  Afaf on 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......

Afaf

Posts : 14
Join date : 2012-09-18

View user profile

Back to top Go down

Re: date object.

Post  Afaf on 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)"

Afaf

Posts : 14
Join date : 2012-09-18

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum