Get the date from SQL Server

[Alex Baker]

I am currently moving a powerbuilder application from a SQL server 2000 environment to SQL 2005. Easy you would think until I discovered the code was full of this sort of thing select getdate() from sysobjects where id=1 simply to get the current date / time!! In SQL 2005 sysobjects does exist as a compatibility view however the data in it does not contain a record with an id of 1... the application fails in a big way..

Alex Baker

[Rob Smiley]

nasty! did the original programmer not realise that select getdate() would work too?

"An eye for an eye only ends up making the whole world blind"

[PIEBALDconsult]

Looks kinda Oracle-ish -- it could be Oracle ported to SQL Server... badly. I worked for a company that had always used Oracle (on OpenVMS), but one customer wanted SQL Server (6) (on WinNT) so a bunch of PowerBuilder idiots were brought in to write some of the worst code I've ever seen. Data access in the UI?! X|

[supercat9]

The wonderful thing about standards is that there are so many of them. If I recall, I create a variable (in vb.net) with the name of the SQL get-date function, and then I use that. I forget how I set it, but it was something pretty clunky like "If database type looks like SQL Server, set it to GETDATE() otherwise set to NOW()".

[irol]

Hello, How to get miliseconds form MS SQL Server using ADO and C++ ? COleDateTime doesn't support miliseconds ... Best Regards, Irek

[MaksimP]

--You can use 'set' instead of 'select' declare @t as DateTime set @t = getUtcDate() -- Testing-- print @t print DatePart(hh,@t) print DatePart(mm,@t) print DatePart(ss,@t) print DatePart(ms,@t)

[MaksimP]

You can do it sql by using 'DatePart(ms,<dbColumnTime>)' function

[Gordon Kushner]

If I remember right, I think Oracle programmers had to do something like SELECT "Hello World" FROM DUAL because it wouldn't allow a SELECT without a FROM. Could be a recent convert.

[Jane Williams]

You do remember right, and I was trying to forget.