Viewing 15 posts - 22,576 through 22,590 (of 26,490 total)
Try this: select right(convert(varchar(40), getdate(), 109), 14)
February 4, 2009 at 2:09 pm
Jack Corbett (2/4/2009)
February 4, 2009 at 1:59 pm
I dropped the OP a PM. He hasn't read it or is ignoring it. Could also be a time difference as it could be early morning where he...
February 4, 2009 at 1:54 pm
I've been trying to get our PeopleSoft Admin to take a look and offer some assistance too, but she's been a bit busy.
February 4, 2009 at 1:49 pm
latingntlman (2/4/2009)
I apologize. Actually I need to pull the hh:mm:ss from the datetime field. The sample value is 2009-02-04 12:29:49.753Hope this helps,
Little more clarification, you need to pass this for...
February 4, 2009 at 1:46 pm
Clarify please, number of secods from when?
February 4, 2009 at 1:28 pm
Based on that, I don't think there is much you can do to rewrite the query, the query tool would just undo it if I remember correcty (our PeopleSoft admin...
February 4, 2009 at 1:14 pm
NotManyPoints (2/4/2009)
Work on the avatar.
Based on avatar, soccer player (er sorry, football to the world) maybe?
February 4, 2009 at 12:42 pm
NotManyPoints (2/4/2009)
Hybrid dba, Hybrid developer, all round make sure stuff gets done, I don’t know…
News for you I have, most of us you described just now.
Except maybe for big companies,...
February 4, 2009 at 12:41 pm
NotManyPoints (2/4/2009)
Lot of effort on the jedi speak.
Jedi, not. Yoda, yes.
I really don't want to read through all the posts to find where you said "I am a ...",...
February 4, 2009 at 12:35 pm
This is the book I first purchased when i started working with SSIS, and my partner picked it up also:
Professional SQL Server 2005 Integration Services by Wrox.
I keep it with...
February 4, 2009 at 12:31 pm
Some may think. From original post has strayed, but understanding of ones thoughts vital it is.
Why is one thought of less because of knowledge one may lack regarding SQL...
February 4, 2009 at 12:26 pm
Our Finance system is at 8.9 but we are using SQL Server 2005 (HR is at 9.0 and required moving to SQL Server 2005).
We had a performance issue with our...
February 4, 2009 at 12:22 pm
NotManyPoints (2/4/2009)
The question was answered, quite a few times.
If answered, asked again not
February 4, 2009 at 12:10 pm
Viewing 15 posts - 22,576 through 22,590 (of 26,490 total)