API Tables datetime default value

[Trever B]

Hi,

Thanks in advance.

This is driving me crazy.

All i want to do is

in a datetime fiel of a table of an api sql I want to hard code the default
value as
(SQL 2000)

31 Dec 9999 23:59:59

I have lost track of the combinations I have tried.

Please help

Thanks

Trev

 

[Alex Dybenko]

This works at me:
select cast('99991231 23:59:59' as datetime)

so you can make '99991231 23:59:59' as a default

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com