You are here: Re: formatting for a birth date field?? « MsSQL Server « IT news, forums, messages
Re: formatting for a birth date field??

Posted by tlyczko on 09/19/06 12:23

Erland Sommarskog wrote:
> tlyczko (tlyczko@gmail.com) writes:
> > I was looking at the table itself through SSMS 2005,
>
> I don't think so. I think you looked at a textual representation of the
> table, as presented by SSMS.
> I believe that when you run a SELECT query, you always get ISO format,
> but in Open Table regional settings are applied. I cannot really tell
> for sure, since my regional settings agree with the ISO format.

Hello, both ideas make sense, however, I now just need to learn how to
update all the fields such that the TIME part for each datum is
00:00:00.etc., I don't need to worry about the time in a birth date
field or anything similar...I'll do this as a separate post.

Thank you, Tom

 

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

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