Sorry misunderstood question (brain half asleep and the other half working...)
SELECT DISTINCT
CONVERT(nvarchar(2), DAY(dttCreated)) + '/' +
CONVERT(nvarchar(2), MONTH(dttCreated)) + '/' + CONVERT(nvarchar(4), YEAR(dttCreated))
AS [date]
FROM tablename
will work in SQL server ;)
- James
-----Original Message-----
From: Balaji [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 February 2003 16:10
To: CFAussie Mailing List
Subject: [cfaussie] RE: pick record with same date irnoring time
MS-SQL Server says
TO_DATE is not a function..
--Bal
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of COLLINS,
Rodney
Sent: Friday, February 21, 2003 4:02 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: pick record with same date irnoring time
Don't know what database you're using but,
SELECT DISTINCT(TO_DATE(date_field)) FROM table
Will do it in Oracle, assuming that field used to store the dates is in fact
of "Date" datatype, not character.
Cheers,
Rod.
-----Original Message-----
From: Balaji [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 February 2003 3:08 pm
To: CFAussie Mailing List
Subject: [cfaussie] pick record with same date irnoring time
Hi,
I want to pick records from a table with distinct dates ignoring time.
suggestions pls..
--Bal
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
