Hi,
I need to figure how much time passed between 2 times. For example:
(14:00:00 - 13:15:00) * 24 = .75
I need this to later on convert KW to KWh, but that's not the point.
I can not find out how to do this in PL/SQL.
My date/time fields look like this in the DB:
1/23/2010 21:00:00
I would appreciate any suggestions.
Steve
I am looking for a site that allows you to input a project name, choose a doctype, a js library etc. and then generates the directory structure and files to start a web project. I know about project deploy, but it is no longer maintained. There was a new one that was created within the last 2 or 3 months, but for the life of me I can't find it…
I am working on a web applicaton. And what we also create is something that could be described as inline editing. Just to portray thing I am trying to solve I use example of Facebook post.
You have post like.
Steve Jobs added 5 new photos
Steve Jobs is link that redirects to his profile so in HTML, that would be:
<div…
Hello,
I've been noticing this since Windows Vista. I see it on Windows 7, now, as well. In any case throughout the day I notice that my computer makes apparently random device-connect and/or device-disconnect ("boink") sounds. I suppose it is the same sound you hear when connecting or disconnecting a USB device such as…
Hello,
I've been noticing this since Windows Vista. I see it on Windows 7, now, as well. In any case throughout the day I notice that my computer makes apparently random device-connect and/or device-disconnect ("boink") sounds. I suppose it is the same sound you hear when connecting or disconnecting a USB device such as…
hi guys ,am having trouble with new pioneer dvdr-219l dual layer burners ,have replaced old burners with these dual layer ones . they are sata attached ,have tried img burn, xbox360 cookie burner, dvd decrypter, dvd flick , the burners seem ok burning cd and normal dvds but when trying to burn an iso to dual layer they will…
I asked this question on the MySQL forums and got no answer.
I asked on StackOverflow and received a recommendation to try on ServerFault.
So here I am.
I recently successfully installed the 64 bit version of mysql-5.5.8 on a MacBook Pro in the /usr/local directory.
To address a completely unrelated software (RVM…
I'm running dhcp-4.0.2 server and bind-9.6.1-P3.
When a new Mac OSX DHCP client with the name "harry" connects to the network, the DHCP server gives it a lease, and adds appropriate A & PTR records via DDNS. This works fine; harry.my.domain points to (e.g.) 192.168.1.3, the Mac client knows that its name is…
I have seen automated support ticketing systems which will email the user as soon as their ticket is created with a custom email address for that ticket.
For example, support_ticket_1234@example.com
Does postfix support such a system? Are there any examples out there that might explain how this system might…
My laptop can't reboot. Any time something restarts the laptop (e.g. to apply Windows updates, or Start Menu-Restart, etc), the computer sits at a black screen with the message "Invalid partition" displayed in console text. When this happens, I power off the computer, then power it back on, and it boots up…
New Ubuntu User Needs Help!- version 9.10 does not communicate with laptop
Hello folks,
Several days ago, I installed Ubuntu 9.10 onto my Acer Aspire 3100 laptop, running it alongside Widows Vista as a dual-bootable system. Creation of the Ubuntu boot CD went fine, and the installation onto my hard drive…
As I understand it, the bill forces all Americans to have health insurance. However, I think that the fine for having no health insurance is around $750. But after the year 2014, health insurance companies will not be able to turn customers away for preexisting conditions. Why wouldn't someone pay the fine…
I have a couple of Dell Inspiron 6000 notebooks that work perfectly fine unless you pick them up by one corner (as most people would). When you lift the notebook it flexes slightly and the notebook shorts out. Sometimes even a gentle bump will cause this to happen. So far the notebook always starts back…
I'm a heavy web user that uses the address bar constantly while browsing the web. I often use Ctrl + T to open a new tab or Ctrl + D to move focus to the address bar so it is very annoying that these shortcut keys do not work when a Flash object has focus on the active browser tab.
I would happily give…
I converted my Windows 7 GPT disk to dynamic, which resulted in it being unable to boot. So I used EaseUs Partition Master on my second Win 7 installation to convert the disk back to basic. Now, I have one partition, which is my C: drive, and I can't figure out how to recovery my EFI partition. I no…
When I got my Surface Pro 2, I loved it, and everything seemed to work flawlessly, until, wait for it, windows updates...
The issue that I am having is the following, I primarily use the TC (TypeCover), as the Pro is an out-of-office laptop replacement for me, that I can still use to do whatever I…
Are there any alternatives to IBM Websphere MQ Server for Windows? We need to access a remote Queue Manager that doesn't support client connections (only Queue Manager to Queue Manager).
I've noticed that there are some BizTalk Host Integration adapters but they only seem to behave as clients (one…
We're using VMware on a normal rack mounted server and considering getting another.
I see these days I can pick blade enclosures and servers up for relatively low cost and see the term blade and vm mentioned quite a lot.
So my question - how would a blade setup work with wmware - is the whole…
I am trying to setup my server with a Minecraft server on a non-standard port with a subdomain redirect, which when navigated to by minecraft will go to its correct port, or if navigated to by a web browser will show a web-page. i.e.:
**Minecraft**
minecraft.example.com:25565 ->…
I run an engineering program for class, Quartus 2. The issue i am having is that every time i launch the program, it creates 10 bitmap files in my home directory.
This is not so much of a problem, it just makes my OCD hurt :(
I can delete them without affecting anything, but…
I want to setup roaming profiles for about 50 users. What is the best way to go about doing this? What are the best practices. I've read about desktops/my Documents being TOO big. How big is too big?
We have a few users who keep a lot of media on their machine to listen…
I have a word document template and will be using a hyper link in Excel to access the word file. The issue I need to resolve is making sure once it is opened a message field box is "popped" up asking the user to create a new file name ... (in this case the current date) for…
I'm researching into the best methods of two new parts of our infrastructure, hopefully finding a single solution for both.
1) We're currently running a single application server, and we're going to be adding an additional application server and load balance between the…