Archive for March, 2010

Date Formatting In SQL

image

I got a request for a report the other day so I built this massive 90 line SQL statement to pull all the data requested. So I sent off a copy of the data report and the guy tells me that he needs the date formatted (YYYYMMDD) instead of (YYYY-MM-DD-HHMMSS) and then he was like is that going to be a problem and I was like ha not really. Give me a moment and I’ll send you a simple. Since I can’t remember the correct expression I did a quick Google search and came across this awesome page http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/ covering exactly what I was looking for.

2010
03/19
CATEGORY
Microsoft
SQL
Work
Write comment

The 2nd Online Training Announced

The next online training will be on Monday the 15th. We will be learning about how to make on online survey and taking a look at three products in the market all of which are free. We will also learn how to build a survey using the Google Docs platform. Training is open to the first 50 people with 33 seats allocated to the state staff. Sign up for the training using the widget on the right side.
2010
03/09
CATEGORY
Jaycees
Ranting on
Write comment