Actually there is two questions that bug me. \r\n1. that will be simple I\'m apparantly can\'t too blind to make out a way to default a datetime column to the equivalent of NOW \r\n2. thats more comestic but ... \r\n
\r\n
Code:
\r\n
SELECT t1.f1, t2.f1 AS \'blub\', ....\r\nFROM t1, t2\r\nGROUP BY t1.f1, t2.f1
\r\n
now I havent yet managed it to display t2.f1 in any other the then format the SQL server like best (2005-07-27 00:00:00) and thats no good .I\'ve tried a CONVERT in the SELECT statement and in the GROUP statement but to no avail any help would be appreciated. \r\n \r\nMike
\r\n \r\n\r\n
\r\n
\r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n
\r\n __________________ \r\n there are always two sides of a story and 12 ways to sing a song or write some code. so whats wrong ? \r\n \r\nAvatar by lebb\r\n
Actually there is two questions that bug me.
1. that will be simple I'm apparantly can't too blind to make out a way to default a datetime column to the equivalent of NOW
2. thats more comestic but ...
Code:
SELECT t1.f1, t2.f1 AS 'blub', ....
FROM t1, t2
GROUP BY t1.f1, t2.f1
now I havent yet managed it to display t2.f1 in any other the then format the SQL server like best (2005-07-27 00:00:00) and thats no good .I've tried a CONVERT in the SELECT statement and in the GROUP statement but to no avail any help would be appreciated.
Mike
__________________
there are always two sides of a story and 12 ways to sing a song or write some code. so whats wrong ?
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET. subscribe
\r\n\r\n\r\n
SQL server and dates :(
Threaded Mode
