Ever wanted to get in MSSQL the current date in a "yyyy-mm-dd 00:00:00.000" format?
Maybe there is a better solution, but here is the one i know about:
Select Convert(datetime, Convert(varchar(20), GetDate(), 112), 120)
(10 votes)
(10 votes)
Categories
ScriptLance
ScriptLance Projects
Recent Entries
Recent Comments
- Query of Queries weirdness
Ed said: Ben, yes, it was brought to my attention when this was happening with a DB. I mean that getTMP was a... [More] - Query of Queries weirdness
Ben Nadel said: Ed, funky stuff. Query of queries can be very strange sometimes. I am curious, does the same thing h... [More] - Query of Queries weirdness
KC said: I have had a similar problem for a while, and I think it has something to do with the hyphen (-) bec... [More] - Query of Queries weirdness
Ed said: yes, QueryNew was used ONLY for problem illustration. At real there was a database table with varcha... [More] - Query of Queries weirdness
Brian Swartzfager said: Hi, Ed, I'm not sure if you used QueryNew simply to illustrate a problem you were having with a q... [More]
Calendar
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 |
Open Source
Search
Recommended Music
Tags Cloud
1ssblog about adobe ajax another better: blogcfc caching cfemmys cffirewall cfhssf cfsqlmaster cfwatcher coldfusion community eurovision flex fun indexes knowing list moldova mssql my projects other over ria server sites sql
RSS
Subscribe
Enter your email address to subscribe to this blog.
Adobe Feeds
- Flash Tutorial - Advanced full flash site - Part 1
- Create a Flash game like PixelField - part 2
- ColdFusion 8.01 Installation Minefield
- Position at Adobe : Work on the ConnectNow / Cocomo SDK Team
- ActionScript Hero.org invited to Flash On Tap 2008!
- Adobe MAX 2008 Plans Finalized
- Presentation: Filthy Rich [Flex] Clients
This version doesn't rely on string formatting or conversion to and from string formats :)
Convert(datetime, GetDate(), 121)
because your solution would not be in a "yyyy-mm-dd 00:00:00.000" format.