Calling all database geeks!
PROBLEM: working with MS SQL, how do you change the definition of the day by
time so that when you pull records from a certain span of days it will retrieve
everything cover in those days. Or can you redefine the day?
EXAMPLE: You try to pull records added from Monday-Friday. The database is
retreiving records created from Monday at midnight until Friday at midnight,
thus not giving records that were created on Friday.
Can you change this so that when you ask for Monday-Friday you can get all of
the records that were created on these days?
I suppose one solution would be to request Monday-Saturday, but it needs to be
user-friendly and not confusing to people who do not work with the database
regularly.
Any help would be appreciated!
Jillian Lashmett, Librarian I, I&R
Cumberland County Public Library & Information Center
Headquarters Library
300 Maiden Lane
Fayetteville, NC 28301-5000
Phone (910) 483-7727, x224 / Fax (910) 486-6661
[EMAIL PROTECTED]
