€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides.
|
€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides. |
10-25-2010, 01:01 PM
|
#1 |
|
8/30/14 - Disneyland -10k or Bust.
Join Date: Jan 2005
Posts: 9,022
     |
Any SQL Guru's out there?
I'm spacing on this one....
I have a SQL table with the time stored as the number of milliseconds since midnight (I think). How do I get from 5,677,528 back to 11:16am?
__________________
- Taking it one step at a time.
|
|
Submit to Quotes
|
|
10-25-2010, 01:15 PM
|
#2 | |
|
Not Tref
Join Date: Jan 2005
Posts: 2,188
|
Quote:
__________________
Tref3.0 Listen in aural 3-D to Pop's muzak! (New songs added semi-bi-daily)  j & j Did you know that Emas eht yltcaxe is exactly the same spelled backwards?! |
|
|
|
Submit to Quotes
|
|
10-25-2010, 02:10 PM
|
#3 |
|
SQUIRREL!
Join Date: Jan 2005
Location: On the curbside.
Posts: 5,098
|
Well, let me pry open a box that's been stored in the back of my brain for 4 years. I recall it being a very simple code fix...
I think it's something like dbo.FormatDateTime('SHORTDATE') Lemme know if that sets you on the right track, and if not, I'll open one of my old tables.  |
|
|
Submit to Quotes
|
|
10-25-2010, 03:00 PM
|
#4 | |
|
check your head
Join Date: Oct 2005
Posts: 4,174
|
Quote:
__________________
 a clear conscience is a sure sign of a fuzzy memory |
|
|
|
Submit to Quotes
|
|
10-25-2010, 03:32 PM
|
#5 |
|
Prepping...
Join Date: Jan 2005
Location: Here, there, everywhere
Posts: 11,405
|
select * from dbo.coworkers
where coworkers = 'helpful' 2 results returned. |
|
|
Submit to Quotes
|
|
10-25-2010, 04:20 PM
|
#6 | |
|
8/30/14 - Disneyland -10k or Bust.
Join Date: Jan 2005
Posts: 9,022
|
Quote:
I found what I needed. After checking my math I figured out the values where 100's of a second not milliseconds. However SQL does not seem to have a centisecond option so I ended up converting to milliseconds anyways. rtrim(substring(Convert(varchar,dateadd(ms,time*10 ,'2010-10-2'),13),13,5)) did the trick.
__________________
- Taking it one step at a time.
|
|
|
|
Submit to Quotes
|
|
10-25-2010, 04:56 PM
|
#7 |
|
ohhhh baby
Join Date: Jan 2005
Location: Parental Bliss
Posts: 12,364
|
My husband must be in meetings all day.
__________________
The second star to the right shines in the night for you |
|
|
Submit to Quotes
|
|
10-25-2010, 06:33 PM
|
#8 |
|
I Floop the Pig
Join Date: Jan 2005
Location: Alternative Swankstyle
Posts: 19,348
|
I could have done the math, but still don't have enough stick time with sql to have the syntax down without a lot of reference/trial and error. And I knew Moonie could do the math, so the syntax was the important part.
__________________
'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ 
|
|
|
Submit to Quotes
|
|
10-25-2010, 07:19 PM
|
#9 | |
|
Chowder Head
Join Date: Jan 2005
Location: Yes
Posts: 18,500
|
Quote:
__________________
The thing about quotes on the internet is that you cannot verify their validity.
- Abraham Lincoln |
|
|
|
Submit to Quotes
|
|
10-25-2010, 07:55 PM
|
#10 | |
|
.
Join Date: Feb 2005
Posts: 13,354
|
Quote:
|
|
|
|
Submit to Quotes
|
Linear Mode
