The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: OT MS SQL2000 question


  • To: "UK HomeAutomation Mail List" <ukha_d@xxxxxxx>
  • Subject: Re: OT MS SQL2000 question
  • From: "Adam Stevens" <adam@xxxxxxx>
  • Date: Mon, 14 May 2001 13:08:02 +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



"Dr John Tankard" <john@xxxxxxx> wrote in message
news:<000d01c0dc65$86452560$0302a8c0@xxxxxxx>...
> Sorry for the OT post,
>
> I want to select from MS SQL2000 rows by a timestamp, but I only want
to
use
> the date part,  in DB2 you could do:-

Try using "convert (char(10), <datefield>, 103)".  the
"103" format will
always convert the time/date into a date in the format
"dd/mm/yyyy".

for example, to select all rows with todays date (14/5):

select date
from table
where convert(char(10),date,103) = '14/05/2001'

Adam.




Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.