I have a table in which there is one column, EnteredDateTime. This column contains the date and time. How do I get only the date instead of the date and time?
SELECT GETDATE()   Returns: 2008-09-22 15:24:13.790  I want that date part without the time part: 2008-09-22 00:00:00.000  How can I get that?
Static nested class in Java, why? Mixing C Structs and Objective-C Properties SSL password on apache2 restart I setup wildcard SSL certificate from Godaddy on Apache2. Whenever the server restarts it asks for the passphrase for the SSL certificate's private key.    What's the best way to remove this obstacle to restarts, because when logfile rotation restart occurs in the middle of the night, the server doesn't come back up, and I get an unhappy client call in the morning, as it is a shared server. If $a > b$, is $a^2 > b^2$? Given $a &gt; b$, where $a,b ∈ ℝ$, is it always true that $a^2 &gt; b^2$? UPDATE statement to re-assign a column value according to a numeric formula Why is this simple Excel calculation not netting Zero? Subtracting (erasing) polygons from polygon using ArcGIS for Desktop? How do I access folders created on Ubuntu with Windows? I have an external hard drive on which I back up my files, and I've moved some files from an Ubuntu laptop to it as well. However, I can't find a way to open the folder containing these files with my main Windows 10 laptop. When I try to open the folder "VPC 3 : UBUNTU" (the "VPC" is just a name for the laptop  with no special implications), the following happens:  It responds with "___ is unavailable. Make sure the disk is inserted..." How to get RGB values from UIColor? Support for OpenID ended on July 25, 2018 "EOL while scanning single-quoted string"? (backslash in string) Register On-Click Event with jQuery - Not Firing I have this input:  sdkxyosl 1 safkls 2 asdf--asdfasxy_asd 5 dkd8k  jasd 29 sdi44sw 43 asasd afsdfs 10 rklyasd 4   I need this output:  sdi44sw 43 dkd8k  jasd 29 asasd afsdfs 10 asdf--asdfasxy_asd 5 rklyasd 4 safkls 2 sdkxyosl 1   So i need to sort the lines by the last column.  I don't know how many columns are in one line.  I just can't figure it out, how to do it. I don't have "perl powers". I just have ~average scripting powers with sed, awk, cut, etc..   Does somebody know how to do it? If Durmstrang and Beauxbatons were hidden from common knowledge, how did people from other schools go to them for the Triwizard tournament? So in GoF, they state that Beauxbatons and Durmstrang are hidden from view and don't have their locations public.     “Durmstrang’s another wizarding school?” said Harry      “Yes,” said Hermione sniffily, “and it’s got a horrible reputation.      According to An Appraisal of Magical Education in Europe, it puts a   lot of emphasis on the Dark Arts.”      “I think I’ve heard of it,” said Ron vaguely. “Where is it? What   country?”      “Well, nobody knows, do they?” said Hermione, raising her   eyebrows.      “Er — why not?” said Harry.      “There’s traditionally been a lot of rivalry between all the magic   schools. Durmstrang and Beauxbatons like to conceal their whereabouts   so nobody can steal their secrets,” said Hermione matter-offactly.   So how do students get to the other school for the Triwizard tournament? Alternatives to one-way ANOVA for heteroskedastic data I have data from 3 groups of algae biomass ($A$, $B$, $C$) which contain unequal sample sizes ($n_A=15$, $n_B=13$, $n_C=12$) and I would like compare if these groups are from the same population.  One-way ANOVA would definitely be the way to go, however upon conducting normality tests on my data, heteroskedascity seems to the main issue. My raw data, without any transformation, produced a  ratio of variances ($F_{\max} = 19.1$) which is very much higher than the critical value ($F_{\rm crit} = 4.16$) and therefore I cannot perform one-way ANOVA.   I also tried transformation to normalise my data. Even after trials of various transformations (log, square root, square), the lowest $F_{\max}$ produced after transformation with a $\log_{10}$ transformation was $7.16$, which was still higher compared to $F_{\rm crit}$.  Can anyone here advise me on where to go from here? I can't think of other methods of transformation to normalise by data. Are there any alternatives to a one-way ANOVA?  P.S.: my raw data are below:   A: 0.178 0.195 0.225 0.294 0.315 0.341 0.36  0.363 0.371 0.398 0.407 0.409 0.432     0.494 0.719 B: 0.11  0.111 0.204 0.416 0.417 0.441 0.492 0.965 1.113 1.19  1.233 1.505 1.897 C: 0.106 0.114 0.143 0.435 0.448 0.51  0.576 0.588 0.608 0.64  0.658 0.788 0.958 DropDown list onchange event and AJAX in MVC Differential Geometry-Wedge product How can we prove the following relation for differentiating the wedge product of a p-form $\alpha_p$ and a q-form $\beta_q$$$d(\alpha_p\wedge\beta _q)=d\alpha_p\wedge\beta_q+(-1)^{p}\alpha_p\wedge d\beta_q$$ What does [&] mean before function? I want to plot this graph, but I don't know how to code the words in the nodes.     Here is my code:  \documentclass{article} \usepackage{amsmath} \usepackage{titletoc} \usepackage{tikz} \usetikzlibrary{trees,positioning,fit}  \begin{document}{\allowdisplaybreaks[4]}  \tikzstyle{bag} = [text width=2em, text centered] \tikzstyle{end} = []  \begin{center} \begin{tikzpicture}[sloped] \node (a) at ( 0,0) [bag] {$\ln r_0$}; \node (b1) at ( 3,1.5) [bag] {$\ln r_{10} + \sigma_1\sqrt{\Delta t_1}$}; \node (b2) at ( 3,-1.5) [bag] {$\ln r_{10}$}; \node (c1) at ( 6,3) [bag] {$\ln r_{20} + 2\sigma_2\sqrt{\Delta t_2}$}; \node (c2) at ( 6,1.5) [bag] {$\textrm{Mean} = \ln r_{20} + \dfrac{3}{2}\sigma_2\sqrt{\Delta t_2}$\\$\textrm{Mean Change} = \mu_{11}\Delta t_2 = \ln\dfrac{r_{20}}{r_{10}} + \dfrac{3}{2}\sigma_2\sqrt{\Delta t_2} - \sigma_1\sqrt{\Delta t_1}$}; \node (c3) at ( 6,0) [bag] {$\ln r_{20} + \sigma_2\sqrt{\Delta t_2}$}; \node (c4) at ( 6,-1.5) [bag] {$\textrm{Mean} = \ln r_{20} + \dfrac{3}{2}\sigma_2\sqrt{\Delta t_2}$\\$\textrm{Mean Change} = \mu_{11}\Delta t_2 = \ln\dfrac{r_{20}}{r_{10}} + \dfrac{3}{2}\sigma_2\sqrt{\Delta t_2} - \sigma_1\sqrt{\Delta t_1}$}; \node (c5) at ( 6,-3) [bag] {$\ln r_{20}$}; \draw [-&gt;] (a) to node [below] {} (b1); \draw [-&gt;] (a) to node [above] {} (b2); \draw [-&gt;] (b1) to node [below] {} (c1); \draw [-&gt;] (b1) to node [below] {} (c2); \draw [-&gt;] (b1) to node [below] {} (c3); \draw [-&gt;] (b2) to node [below] {} (c3); \draw [-&gt;] (b2) to node [below] {} (c4); \draw [-&gt;] (b2) to node [below] {} (c5); \end{tikzpicture} \end{center}  \end{document}       Update code use  \draw [-&gt;] (a) to node [below] {} (b1.south east); \draw [-&gt;] (a) to node [above] {} (b2.north east); \draw [-&gt;] (b1.south east) to node [below] {} (c1.west); \draw [-&gt;] (b1.south east) to node [below] {} (c2.west); \draw [-&gt;] (b1.south east) to node [below] {} (c3.west); \draw [-&gt;] (b2.north east) to node [below] {} (c3.west); \draw [-&gt;] (b2.north east) to node [below] {} (c4.west); \draw [-&gt;] (b2.north east) to node [below] {} (c5.west); The rulebook states that carrying capacity is the strength score times 15 (lbs). Find familiar allows me to get a hawk, which has a strength score of 5. This results in a carrying capacity of 75 lbs. This is well within the range of weights for small people such as gnomes or halflings. Does this mean my familiar can carry them and fly away (given they do not struggle)?