datetime)
sorry about that.
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:53 PM
To: CF-Talk
Subject: RE: Dates - ranges overlapping months... rut-roh
Hey Steve!
I tried that one as well. I kept getting:
Syntax error converting
Candace Cottrell wrote:
> Hey Jochem, I am using Transact-SQL
Sorry, thought you were on Oracle. The idea should work just the
same, but I will leave the exact syntax to people with more T-SQL
experience ;-)
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Tod
((cast(start_month as varchar) +
'/' + cast(start_day as varchar) + '/' + cast(start_year as varchar)) as
datetime)
sorry about that.
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:53 PM
To: CF-Talk
Subject: RE: Dates -
rry about that.
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:53 PM
To: CF-Talk
Subject: RE: Dates - ranges overlapping months... rut-roh
Hey Steve!
I tried that one as well. I kept getting:
Syntax error converting the varchar value
CTED]
Sent: Thursday, January 29, 2004 1:53 PM
To: CF-Talk
Subject: RE: Dates - ranges overlapping months... rut-roh
Hey Steve!
I tried that one as well. I kept getting:
Syntax error converting the varchar value '/' to a column of data type int.
So then I went to:
update oncall_shifts set s
ursday, January 29, 2004 1:28 PM
To: CF-Talk
Subject: Re: Dates - ranges overlapping months... rut-roh
Hey Jochem, I am using Transact-SQL and converted everything but:
UPDATE TABLE table SET shift_start = to_date( start_year || '-'
|| start_month || '-' || start_day, "y
k
Subject: Re: Dates - ranges overlapping months... rut-roh
Hey Jochem, I am using Transact-SQL and converted everything but:
UPDATE TABLE table SET shift_start = to_date( start_year || '-'
|| start_month || '-' || start_day, "-mm-dd");
I tried to do:
UPDATE O
Hey Jochem, I am using Transact-SQL and converted everything but:
UPDATE TABLE table SET shift_start = to_date( start_year || '-'
|| start_month || '-' || start_day, "-mm-dd");
I tried to do:
UPDATE ONCALL_SHIFTS
SET shift_start = CAST(start_month&start_day&start_year AS DATETIME)
But i
Candace Cottrell wrote:
>
> BETWEEN START_DAY AND END_DAY
> AND
> BETWEEN START_MONTH AND END_MONTH
> AND
> BETWEEN START_YEAR AND END_YEAR
>
> does not work when you have a date range that spans more than one month.
> Start_Month = 1
> Start_Day = 18
> Start Year = 2004
>
> En
9 matches
Mail list logo