You are here: Re: How to find the maximum possible value of a given datatype « MsSQL Server « IT news, forums, messages
Re: How to find the maximum possible value of a given datatype

Posted by jshunter@waikato.ac.nz on 06/27/07 02:04

On Jun 27, 1:56 pm, Roy Harvey <roy_har...@snet.net> wrote:
> How about just hardcoding what is in the documentation? DATETIME, for
> example says "Date and time data from January 1, 1753 through December
> 31, 9999, to an accuracy of one three-hundredth of a second
> (equivalent to 3.33 milliseconds or 0.00333 seconds)." Which after
> consulting the accompanying chart comes to 9999-12-31 23:59:59.997.
>
> Roy Harvey
> Beacon Falls, CT

I've had to do just that, but it would be nice if I could have the
view do the job via a function. For example, if the underlying table
changed from a smalldatetime to a datetime, then all views which use
it would automatically return the correct maximum value

--John Hunter

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация