Parameter Object really necessary?

[Cor Ligthert]

Shawn,

I've never "struggled" with date formats or whatever.

May I guess that you live in the USA and never made programs for the
international market.

For me is SQL very much based on USA standards. (One of the reasons that I
hate SQL, not that I hate the USA or its inhabitants, however have to think
forever how certain things and slang are (can be) standard in that country
when I use SQL)

It started as plain USA language.



Cor

 

[Sahil Malik [MVP]]

Cor,

I migrated to USA from India. Might I add - USA has very confusing date
formats because of all the damn foreigners (including me) over here.

- Sahil Malik [MVP]
Upcoming ADO.NET 2.0 book - http://tinyurl.com/9bync

 

[William \(Bill\) Vaughn]

I was born and raised here and I also find the US date format irrational.
However, because there are those of us that are cognizant of other cultures,
we have learned to adapt to diversity. Today, most MS software is sold into
cultures that don't use US date formats. However, SQL Server (and others)
had to settle on a specific internal storage format--it was built in the US
for US markets (which were years ahead of the others at the time) so it
would have been challenged to use some other date format. Hating a product
because of date formatting is...well, silly. You're still free to reformat
dates to any format you choose--most of us do.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Cor Ligthert]

Bill,

The problem is not in SQLserver that uses ticks that started at the time
that the last country (The USA) switched from Julian to Georgian. Any date
before that would give probably unpredictable calculations when it is about
international used dates, so that is not so bad choosen.

The problems are in my opinion pure in the SQL language.

If you use parameters than everything is working very fine especially in
vbnet with Cdate.

Cor

ps. the USA was because it was in that time still a colony from England and
that was as forever with introducing of changes in Europe the last one.

)

 

[Chad Z. Hower aka Kudzu]

Sorry to reply here - but you dont have your email listed.

I didnt know you were in the Netherlands - I was just here a week ago... Maybe we can meet up next
conference Im at there.

 

[Cor Ligthert]

Kudzu,

I know, I live in the area where you was, about 12 miles from there.

My email address is open. Just don't use my first name only my last name



Cor

 

[Chad Z. Hower aka Kudzu]

I know, I live in the area where you was, about 12 miles from there.
Wow!

My email address is open. Just don't use my first name only my last name

Ok - Well I speak at conferences 1-2 times a year in NL, so I guess next year.