how to get time (hh:mm:ss) from sql query ?
- by Gold
hi
i have Database with date field.
i see the time like: 1900-01-01 13:38:00.000
how i can see it like: 13:38 ?
(i work on sql server 2008)
thank's in advance
Search Results
Search found 74197 results on 2968 pages for 'part time'.
Page 250/2968 | < Previous Page | 246 247 248 249 250 251 252 253 254 255 256 257 | Next Page >
-
-
Java JIT compiler compiles at compile time or runtime ?
- by Tony
From wiki: In computing, just-in-time compilation (JIT), also known as dynamic translation, is a technique for improving the runtime performance of a computer program. So I guess JVM has another compiler, not javac, that only compiles bytecode to machine code at runtime, while javac compiles sources to bytecode,is that right?Read the article
-
How do I produce an external URL as part of a replace_html call in Ruby on Rails?
- by vlasits
Basically, I am attempting to render an external website (the url of which is stored in the database) into a page in my Ruby on Rails app. I have a field in my model 'search' called 'search' that contains web addresses with the form 'www.example.com' or 'example.com'. I am trying to use a link_to_function call with replace_html to replace the 'maincontent' div with an iframe tag using the value of 'search' in the current instance as the src for the tag. My current attempt is the very ugly code below. I'd be grateful for either of the following types of responses: How can I rewrite the concatenation string to work correctly? How can I get the same effect (replacing the current content of the "mainContent" div with an iframe tag using a different method? (I had to modify the code before to remove the < from the iframe) link_to_function h(search.title) do |page| page.replace_html 'mainContent', 'iframe id="embedded" src="http://" + #{search.search} />' endRead the article
-
How does Apache process several requests at a time?
- by Vicenç Gascó
In a short question: If 10 requests hit Apache, does it process them one by one, so when R3 finishes, then it starts to run R4, or does it fire 10 processes/threads/whatever and are resolved simultaneously? Now some background: I have a PHP script that takes up to two minutes to do some processes. My question is: while a client is waiting for this 2 minutes, all the other clients requests are being processed? Or also waiting for this one to end? By the way, if there are simultaneous request, how can I handle them? Let's say put a limit on them. Or a limit on resources consumed. For instance I want the server to use its 80% performance on serving the webapp, and just a 20% for those long operations ... because I have no hurry to end them. Doesn't know if it cares but is all in PHP. Thanks in advance!!Read the article
-
Given an array of integers where some numbers repeat 1 time, some numbers repeat 2 times and only on
- by SS
Given an array of integers where some numbers repeat 1 time, some numbers repeat 2 times and only one number repeats 3 times, how do you find the number that repeat 3 times. Using hash was not allowed. Complexity of algorithm should be O(n)Read the article
-
How to programmatically end an ASP.NET session after a given amount of time.
- by vaitrafra
Hi, we're in need to stop the user session in an ASP.NET site after some time(say 20 mins). We know we can use a timer and code every page to expire on the timer tick, but we're searching a faster way, maybe through an IIS configuration? Is there a built in way to do such things? We're using ASP.NET 2.0, Framework 3.5, IIS 6, c#. TY.Read the article
-
How to create a cron job in PHP for getting the update of modified date and time of files/folders?
- by OM The Eternity
How to create a cron job in PHP for getting the update of modified date and time of files/folders? I am a newbie to create a cron job how to get started?Read the article
-
How do you automatically refresh part of a page automatically using AJAX?
- by Ryan
$messages = $db->query("SELECT * FROM chatmessages ORDER BY datetime DESC, displayorderid DESC LIMIT 0,10"); while($message = $db->fetch_array($messages)) { $oldmessages[] = $message['message']; } $oldmessages = array_reverse($oldmessages); ?> <div id="chat"> <?php for ($count = 0; $count < 9; $count++) { echo $oldmessages[$count]; } ?> <script language="javascript" type="text/javascript"> <!-- setInterval( "document.getElementById('chat').innerHTML='<NEW CONTENT OF #CHAT>'", 1000 ); --> </script> </div> I'm trying to create a PHP chatroom script but I'm having a lot of trouble getting it to AutoRefresh The content should automatically update to , how do you make it do that? I've been searching for almost an hourRead the article
-
NHibernate: why ILifecycle.OnUpdate is not called every time ?
- by ldp615
NHibernate_reference.pdf, page 26: Note that ILifecycle.OnUpdate() is not called every time the object's persistent state is updated. It is called only when a transient object is passed to ISession.Update(). Why it design link that?Read the article
-
I'm looking for an efficient algorithm to test whether a given number is part of the fibonnaci seque
- by blueberryfields
Given the number X, is it a fibonnaci number? Any source code or mathematical formula would be ok.Read the article
-
Cursor loops; How to perform something at start/end of loop 1 time only?
- by James.Elsey
I've got the following in one of my Oracle procedures, I'm using it to generate XML -- v_client_addons is set to '' to avoid null error OPEN C_CLIENT_ADDONS; LOOP FETCH C_CLIENT_ADDONS INTO CLIENT_ADDONS; EXIT WHEN C_CLIENT_ADDONS%NOTFOUND; BEGIN v_client_addons := v_client_addons || CLIENT_ADDONS.XML_DATA; END; END LOOP; CLOSE C_CLIENT_ADDONS; -- Do something later with v_client_addons The loop should go through my cursor and pick out all of the XML values to display, such as : <add-on name="some addon"/> <add-on name="another addon"/> What I would like to achieve is to have an XML start/end tag inside this loop, so I would have the following output <addons> <add-on name="some addon"/> <add-on name="another addon"/> </addons> How can I do this without having the <addons> tag after every line? If there are no addons in the cursor (cursor is empty), then I would like to skip this part enitrelyRead the article
-
how to make so that Form2 when you click on Button1 not opened for the second time?
- by Saska
I have the code: private void Button1_Click (object sender, EventArgs e) ( Form2 f2 = new Form2 (); f2.Show (); ) how to make so that Form2 when you click on Button1 not opened for the second time, if it is open? sorry for bad englishRead the article
-
Why does Flex recognize paddingLeft as a property on a component, but not as part of a style?
- by justkevin
In my application this works: <s:VGroup width="100%" paddingLeft="100"> ... stuff ... </s:VGroup> This doesn't: <fx:Style> @namespace s "library://ns.adobe.com/flex/spark"; @namespace mx "library://ns.adobe.com/flex/mx"; .myStyle { paddingLeft: 100; } </fx:Style> <s:VGroup width="100%" styleName="myStyle"> ... stuff ... </s:VGroup> Why not?Read the article
-
which images load the android device at the time of installation?
- by VSC
I am placing 20 images in hdpi folder, 20 images in mdpi folder and 20 images in ldpi folder, all are same images but different resolutions . I am placing my app in android market. One user install my app in his normal android device through market, My question is total 60 images download the device or only 20 images(mdpi) download the device at the time of install the app.Thanks for reading my question.Read the article
-
can i braodcast a UDP package to part of a network ?
- by user314536
i am trying to broadcast a UDP package using subnet. i want to braodcast my package to 192.168.1.255 ? can i do that ? and how using c++ ?Read the article
-
App Engine - Java AppStats - It shows all requests as cpu time of 0.
- by Spines
All lines in my AppStats look like this: real=19ms cpu=0ms api=0ms overhead=0ms, it has the correct real time, but the other values are always 0. Anyone have this problem before or know how to fix this?Read the article
-
MySQL - Limit a left join to the first date-time that occurs?
- by John M
Simplified table structure (the tables can't be merged at this time): TableA: dts_received (datetime) dts_completed (datetime) task_a (varchar) TableB: dts_started (datetime) task_b (varchar) What I would like to do is determine how long a task took to complete. The join parameter would be something like ON task_a = task_b AND dts_completed < dts_started The issue is that there may be multiple date-times that occur after the dts_completed. How do I create a join that only returns the first tableB-datetime that occurs after the tableA-datetime?Read the article
-
Minimal time interval between sending requests to Google Products without CAPTCHA entering?
- by user330564
Can anybody help me? Maybe anybody knows which minimal time interval between sending requests to Google Products without CAPTCHA entering? Thanks.Read the article
-
Get URL parameter function that gets value of url part or returns true if it's there but with no val
- by LLer
I'm using the following function to get a URL parameter. function gup(name, url) { name = name.replace(/[\[]/, '\\\[').replace(/[\]]/, '\\\]'); var results = new RegExp('[\\?&]'+name+'=?([^&#]*)').exec(url || window.location.href); return results == null ? null : results[1]; } It works only if the parameter has a value, for example. gup('a', 'http://example.com/page.php?a=1&b=2'); will return 1. But if I try gup('a', 'http://example.com/page.php?a&b=2'); It returns null. I want it to return true because parameter "a" exists in that url, even though it has no value it's still there and gup() should return true. Could I get a bit of help rewriting this? I'm not that good with regex.Read the article
-
How to log user activity with time spent and application name using c#.net 2.0?
- by user342777
hi, I am creating one desktop application in which I want to track user activity on the system like opened Microsoft Excel with file name and worked for ... much of time on that.. I want to create on xml file to maintain that log. Please provide me help on that.Read the article
-
How do I combine two rows of same part, but add quantities?
- by Tom
I have table "PICKITEM" PARTID QTY A 1 A 3 B 11 C 8 D 5 D 3 I need a select statement that will return one line for like PARTIDs and add the qty field to together, yet also return the rest of the lines in the table as is PARTID QTY A 4 B 11 C 8 D 8 Probably a newb question, but I am new to SQL syntax and queries. Any help in getting me on the right path would be appreciated!Read the article
-
What is time complexity for find method in a set in c++?
- by tsubasa
set<int> s; s.insert(1); s.insert(2); ... s.insert(n); I wonder how much time it takes for s.find(k) where k is a number from 1..n? I assume it is log(n). Is it correct?Read the article
-
How can one display local time and date to my drupal website visitors depending upon their geographi
- by Saurabh
I need to display the FIFA world Cup 2010 schedule on my Drupal website. But what I want is that each visitor should be able to see the time for the upcoming matching as per his/her own geographic location . How can this be done ?Any suggestions would be welcomed. Thanks for reading this through.Read the article
-
"Facebook Like" - Time & Effort required to integrate with an existing e-commerce site?
- by hamlin11
How much time, and what basic steps, are involved in integrating the "Facebook Like" feature into an existing e-commerce site? Let's say we are only interested in the feature at the product details level and have approximately 5 different product details areas. Any recommended tutorials perhaps? ThanksRead the article
-
How to reduce time for taken by stored Procedure for inserting a single record?
- by padmavathi
We wrote a stored procedure for selecting a single record from DB at a time. Using the same stored procedure to read 2000 records it takes 4 seconds. Is there any way to optimize it? (like single stored procedure for 2000 records) Thanks & Regards PadmaRead the article
