The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

[OT] SQL Query


  • Subject: [OT] SQL Query
  • From: "Stuart Whyte" <lists@xxxxxxxxxxxxxx>
  • Date: Fri, 6 Aug 2004 07:47:59 +0100

Hello SQL Gurus ;-)


I have a field in an access database that is (like) 20040804125000.

Clearly this is year/month/day/hour/minute/second.

What can I put to only get the first 8 characters (ie date only)

Thx in advance

Stuart


[Non-text portions of this message have been removed]




UKHA_D Main Index | UKHA_D Thread Index | UKHA_D Home | Archives Home

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.