I have a SQL Server table that has a datetime column. What I need to do with a SELECT statement is return (I think) a calculated column that takes the time from the datetime column and puts it together with the current date.  So in the table I may have...  [TargetPlot].[TargetDate] 2015-12-09 10:15:00 2015-12-09 10:30:00 2015-12-09 10:45:00 2015-12-09 11:00:00 2015-12-09 11:15:00   But what I need the SELECT statement to return is (assuming the current date is December 11th)...  [SomeCalculatedField] 2015-12-11 10:15:00 2015-12-11 10:30:00 2015-12-11 10:45:00 2015-12-11 11:00:00 2015-12-11 11:15:00   Thanks for any advice.  Andy
In an extract I am dealing with, I have 2 datetime columns. One column stores the dates and another the times as shown.  How can I query the table to combine these two fields into 1 column of type datetime?  Dates  2009-03-12 00:00:00.000 2009-03-26 00:00:00.000 2009-03-26 00:00:00.000   Times  1899-12-30 12:30:00.000 1899-12-30 10:00:00.000 1899-12-30 10:00:00.000
Prove that $f(x)\in \mathbb{Z}[x]$ such that $f(0)$ and $f(1)$ are odd has no integer roots For bash script, I can use "$@" to access arguments. What's the equivalent when I use an alias? I've recently bought a new Android smartphone. After setting it up and loading my contacts onto it I thought that would be it.  Now after some days, every time I unlock the phone it takes a few seconds before it opens the default browser and opens some spam website. I tried to see what was causing it. I removed any apps I didn't know I could trust, but the problem persisted. After trying to solve it for some time I gave up and reset the phone to factory default. Now after having it reset to the default it ran without issues for roughly a week before the problem reappeared.    I tried to uninstall some apps in order to see if they were to cause of it, but nothing changed after doing so. However I did notice that if I turn off the wifi it won't even try to open the browser (I haven't tried mobile data since I don't have a bundle). This makes me feel like it might be related to something on the network but that wouldn't explain why only that phone would have the issue when there are at least 6 android phones on that very same network.  I hope that there is someone who can help me find the cause of this issue and help me solve it.  TL;DR When unlocking my phone, it opens the browser and tries to open a spam website. But only does so while connected to the wifi.  Things I've tried so far:   Factory reset (only helped for a limited time) Clearing the browser cache and all related data  Removing any app I don't know to be reliable Attempting to find what triggers it (seems like some type of internet connection is required??)   The device is the Doogee Shoot 1. As for the browser, the default is set to be the Android browser, but if I change the default it would use Chrome just as well. It seems to really just use the browser that is set to default. Experimental observation of matter/antimatter in the universe Ordinary matter and antimatter have the same physical properties when it comes to, for example, spectroscopy. Hydrogen and antihydrogen atoms produce the same spectroscopy when excited, and adsorb the same frequencies. The charge does not make a difference in the potential (regardless if it's generated by a proton or an antiproton) nor in how the positron behaves in this potential (being its mass equal to the mass of an electron)  How can astronomy evaluate if a far galaxy is made of matter or antimatter, given that from the spectroscopy point of view, they behave in the same way? In other words, how do we know that an asymmetry exists between matter and antimatter in the universe? I am working on a game and would like to include a few jump scares. So here is a rather simple question — What makes a good jump scare and when and how should they happen? MySQL 5.5.16 allows anonymous connections Apparently, I can connect to MySQL (at least from my localhost) without having to provide any username or password. I can even put anything as username, as long as the password is empty. I have access to the information_schema and test databases. I can create tables. If I run SELECT USER() it returns the proper value randomstring@localhost, where the random string is whatever I used for username when I connected.  The mysql.user table contains root@localhost, root@127.0.0.1, @localhost and pma@localhost. I manually set encrypted passwords to all the records (UPDATE user SET password=...) and only root has any privileges, the other two records have "N" for all privileges. That record with the empty username looks suspicious, but I don't think it has anything to do with this and I think it was there from the beginning.  To make matters worse, if I add a user with a password, I can only connect using empty string as password (just like if I put anything as username). If I try to connect using the username I created and password I supplied when creating it (CREATE USER .. IDENTIFIED BY ..) it doesn't work.  Does anyone know what is wrong and how I can fix this?  Note: I am using MySQL 5.5.16 for Windows, provided by the XAMPP package. Finite Sets, Equal Cardinality, Injective $\iff$ Surjective. I found this heart while exploring the crimson biome - what is it? Python BeautifulSoup findAll by "class" attribute Which year does Spider-Man: Homecoming take place in? When umpire change the cricket ball, was the old ball thrown as waste or keep for reuse? Padding trailing whitespaces in a string with another character I'd like to output hello world over 20 characters.  printf "%-20s :\n\n" 'hello world!!'  # Actual output hello world!!        :  # Wanted output hello world!!========:   However, I don't want to complete with spaces but with "=" instead. How do I do that? Misplaced navigation bar and question title Does $\{f_ng_n\}\to fg$ uniformly? Why are there two Address lines in Address forms? Experience and a quick Google Images search suggests that it's standard to provide two fields for Address/Street. A colleague argues that it's perceived as two alternative addresses, and that the fact that there's only one country, state, zip, phone just makes it more confusing. I tried to think of a good explanation for having two fields but couldn't. To the reason of "there are some very long addresses" he replies "then why don't they use a multiline input field which would make it clearer that it's the same address".  So, what's the reason? And is it only standard for the US or for Europe as well? Xcode - How to fix 'NSUnknownKeyException', reason: … this class is not key value coding-compliant for the key X" error? How do you end with a single quote followed by a double quote? I have a paragraph as follows:  ``This is a quote. `Here is a quote within a quote.'''   But the formatting works out to be a double quote (") followed by a single quote (') instead of the other way around. How can I solve this problem? pgfplots fillbetween with multiple curves What does each AMS package do? In my view, any document with a substantial amount of mathematics should load the packages from AMS-TeX. Hence, most of my document's preambles contain  \usepackage{amsmath, amsthm, amssymb, amsfonts}   (I could add to that the non-AMS mathtools, etc.). What do each of those packages do? Do I really need to list all of them, or do some of them load others? In particular, does any package load all of them, so that I can simply type  \usepackage{ams-everything}   shorter than the current list? Eclipse was working as good as anything on 14.04. I did a clean install of 16.04 and installed Eclipse. But it runs a Java program only once after which it just hangs during subsequent attempts before I remove and reinstall it. I have tried many things, since in the beginning I needed CDT as well. Right now, I just want to remove everything related to eclipse and do a fresh install (remove all the configs and dependencies). Please note that I used Eclipse installer to install Eclipse and the eclipse icon image is also not appearing (the default ubuntu ? is appearing).