Posted by MC on 07/11/05 13:23

You probably have a problem with dateformat. It is probably in a year, day,
month format and there isn't 15 months in a year :).

try this:

insert into calendar
tema, pol_1, dodal, date_from, date_to, user_id, status) Values ('test' ,
'test' , 1, '2005-09-08 12:00:00', '2005-15-08 12:00:00', 2, 0 )

or setting the format on and then inserting:


SET DATEFORMAT ymd

insert into calendar
(tema, pol_1, dodal, date_from, date_to, user_id, status)
Values ('test' , 'test' , 1, '2005-08-09 12:00:00', '2005-08-15 12:00:00',
2, 0 )




MC


"Zibi" <nospam@won.com> wrote in message
news:datfo0$bn3$1@nemesis.news.tpi.pl...
> Sometimes I get error : "The conversion of char data type to smalldatetime
> data type resulted in an out-of-range smalldatetime value. "
> If I look on SQL there is ok example with error - insert into calendar
> (tema, pol_1, dodal, date_from, date_to, user_id, status) Values ('test' ,
> 'test' , 1, '2005-08-09 12:00:00', '2005-08-15 12:00:00', 2, 0 )
>
> Example no error - insert into calendar (tema, pol_1, dodal, date_from,
> date_to, user_id, status) Values ('test' , 'test' , 1, '2005-01-01
> 12:00:00', '2005-01-01 16:00:00', 1, 0 )
> What is bad?
>
>
> Regards,
>
>

[Back to original message]