June 13, 2007 at 7:02 pm
"Minimal thinking effort is always useful in programming"
My theory goes:
The entire human progress was driven by the lazy ones.
The whole objective of the progress is to have more with doing less.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
June 13, 2007 at 7:08 pm
Jeff,
Is this why we pay so much for the phone service?
So they can pay you big bucks to write functions like this?
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
June 13, 2007 at 7:12 pm
Absolutely agree.
They were thinking instead of digging.
You can still type all those dates on a typewriter (if you can find one ), but you (and me) are too lazy to do it. So you need to think how to teach machine to do your job while you're wasting company's time on this forum.
_____________
Code for TallyGenerator
June 13, 2007 at 8:26 pm
Heh... no... they only paid me the big bucks to round UP your minutes
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2007 at 8:40 pm
They actually pay someone else to round down your minutes.
It's you who suppose to place right function on back end to round it up.
_____________
Code for TallyGenerator
June 14, 2007 at 6:36 am
"Precisely"
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2007 at 9:32 am
OK:
....Could be that I am missing something:
In SQL QUERY ANALYZER, when I run:
PRINT CONVERT(DateTime, GetDate(), 20) OR
PRINT CONVERT(DateTime, GetDate(), 120)
I get:
Jun 14 2007 9:26AM
So the formatt: YYYY-MM-DD HH:MM:SS did not take.
... any further leads?
Anthony
June 14, 2007 at 9:36 am
PRINT CONVERT(VARCHAR, GetDate(), 20)
PRINT CONVERT(VARCHAR, GetDate(), 120)
In your example you just converted from datatime to datetime (so the format just got ingnored - or maybe even the conversion) and the QA used the default setting to display the date
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
June 14, 2007 at 6:22 pm
The PRINT statement just performed an implicit conversion of your nicely converted datetime to varchar
--------------------
Colt 45 - the original point and click interface
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply