Viewing 15 posts - 2,776 through 2,790 (of 9,399 total)
The CONVERT function supports the format you want to use. Just apply it to a column instead.
SELECT CONVERT(Varchar(10), GETDATE(), 110);
August 10, 2016 at 5:14 am
whereisSQL? (8/9/2016)
Manic Star (8/9/2016)
Kaye Cahs (8/9/2016)
Hugo Kornelis (8/9/2016)
Ed Wagner (8/9/2016)
djj (8/9/2016)
Ed Wagner (8/9/2016)
whereisSQL? (8/9/2016)
Revenant (8/9/2016)
Ray K (8/9/2016)
Luis Cazares (8/9/2016)
Grumpy DBA (8/9/2016)
ThomasRushton (8/9/2016)
Ed Wagner (8/9/2016)
Entanglementhairball
* Cough *
Sneeze
Gesundheit
German
Engineering
Design
Style
Sheet
Music
Dance
Shoes
Socks
Sandals
August 9, 2016 at 4:40 pm
djj (8/9/2016)
Ed Wagner (8/9/2016)
whereisSQL? (8/9/2016)
Revenant (8/9/2016)
Ray K (8/9/2016)
Luis Cazares (8/9/2016)
Grumpy DBA (8/9/2016)
ThomasRushton (8/9/2016)
Ed Wagner (8/9/2016)
Entanglementhairball
* Cough *
Sneeze
Gesundheit
German
Engineering
Design
Style
Sheet
August 9, 2016 at 11:00 am
TomThomson (8/9/2016)
Phil Parkin (8/9/2016)
This code was generated by a tool.
Does anyone else subconsciously say "You can say that again" whenever they read this comment in auto-generated code? 🙂
It's more appropriate...
August 9, 2016 at 9:18 am
whereisSQL? (8/9/2016)
Revenant (8/9/2016)
Ray K (8/9/2016)
Luis Cazares (8/9/2016)
Grumpy DBA (8/9/2016)
ThomasRushton (8/9/2016)
Ed Wagner (8/9/2016)
Entanglementhairball
* Cough *
Sneeze
Gesundheit
German
Engineering
Design
August 9, 2016 at 9:17 am
Learned something new today, so thank you.
August 9, 2016 at 5:48 am
djj (8/9/2016)
ZZartin (8/8/2016)
whereisSQL? (8/8/2016)
Luis Cazares (8/8/2016)
Ed Wagner (8/8/2016)
Hugo Kornelis (8/8/2016)
Ed Wagner (8/8/2016)
whereisSQL? (8/8/2016)
Ray K (8/8/2016)
Ed Wagner (8/8/2016)
SwingJazz
Trumpet
Trombone
Seventy-Six
1776
1984
Leap
Quantum
Particle
Entanglement
August 9, 2016 at 5:44 am
Hugo Kornelis (8/8/2016)
Ed Wagner (8/8/2016)
whereisSQL? (8/8/2016)
Ray K (8/8/2016)
Ed Wagner (8/8/2016)
SwingJazz
Trumpet
Trombone
Seventy-Six
1776
August 8, 2016 at 1:30 pm
whereisSQL? (8/8/2016)
Ray K (8/8/2016)
Ed Wagner (8/8/2016)
SwingJazz
Trumpet
Trombone
August 8, 2016 at 1:04 pm
TomThomson (8/8/2016)
Hugo Kornelis (8/8/2016)
whereisSQL? (8/8/2016)
Luis Cazares (8/8/2016)
Revenant (8/8/2016)
djj (8/8/2016)
Sergiy (8/8/2016)
Grumpy DBA (8/8/2016)
Ed Wagner (8/8/2016)
Hugo Kornelis (8/7/2016)
SQLRNNR (8/7/2016)
ragequit
Resign
Celebrate
life
Death
Loss
Win
Tie
Bow
Curtsy
Swing
August 8, 2016 at 12:47 pm
Nice question to get the grey matter moving on a Monday morning. Simple and straightforward. Thanks.
August 8, 2016 at 5:27 am
Hugo Kornelis (8/7/2016)
SQLRNNR (8/7/2016)
ragequit
Resign
August 8, 2016 at 5:23 am
I also appreciate an easy one to end the week. Since this was the first week after vacation, it was a long one.
August 5, 2016 at 5:57 am
jasona.work (8/5/2016)
August 5, 2016 at 5:55 am
whereisSQL? (8/4/2016)
djj (8/4/2016)
Luis Cazares (8/4/2016)
Ray K (8/4/2016)
Grumpy DBA (8/4/2016)
crookj (8/4/2016)
Ed Wagner (8/4/2016)
Sergiy (8/3/2016)
Revenant (8/3/2016)
Ray K (8/3/2016)
Luis Cazares (8/3/2016)
CouplesSingles
Kraft
Sour
Sweet
bitter
IPA
Lager
Ale
Hops
Flavor
Natural
August 4, 2016 at 11:29 am
Viewing 15 posts - 2,776 through 2,790 (of 9,399 total)