[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: OT MS SQL2000 question
- To: <ukha_d@xxxxxxx>
- Subject: RE: OT MS SQL2000 question
- From: "James Hoye" <james.hoye@xxxxxxx>
- Date: Mon, 14 May 2001 12:29:11 +0100
- Delivered-to: rich@xxxxxxx
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
This email was delivered to you by The Free Internet,
a Business Online Group company. http://www.thefreeinternet.net
---------------------------------------------------------------
> but SQL2000 does not have current date, ou use getdate() which returns
a
> full time stamp of now which would only return a result set of rows
where
> the coloum created is exactly on the same time ?
>
> Is there a easy way of saying 'although created it a timestamp return
rows
> created today' ?
possibly something like:
WHERE <timestamp> >= Format(GetDate(),"YYYY-MM-DD
00:00:00") AND <
Format(GetDate()+1,"YYYY-MM-DD 00:00:00")
I'm no SQL expert, but it might help a little (PS it's pseudo-SQL and I
would be amazed if it was syntactically correct!)
James H
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Home |
Main Index |
Thread Index
|