DateTim sqlTime;
try {
  m_db.Open();
  using (SqlCommand cmd = new SqlCommand("SELECT GetDate() AS [CurrentDateTime]", m_db)) {
    SqlDataReader r = cmd.ExecuteReader();
    while (r.Read() == true) {
      sqlTime = (DateTime)r["CurrentDateTime"];
    }
  }
} catch (InvalidOperationException e) {
  Console.WriteLine(e.StackTrace);
  sqlTime = DateTime.Now;
} catch (SqlException e) {
  Console.WriteLine(e.StackTrace);
  sqlTime = DateTime.Now;
} finally {
  m_db.Close();
}

quote:

---

Originally posted by jp2code

Why did my post come out as a hyperlink?

---

Avoid Sears Home Improvement

---

quote:

---

I like using store procedures because it allows me to specify what the format of my values are going to be ahead of time however, the SQL command SELECT GetDate does not have this option.

Below is how I solved it, and I am looking for advice as to whether or not it is a good technique or if there is something more elegant:

Particularly of interest: Do I need to cast the CurrentDateTime to a DateTime object, or should the SqlDataReader already be returning it in this format?

---

DateTime sqlTime;
try {
  m_db.Open;
  using (SqlCommand cmd = new SqlCommand("SELECT GetDate AS 'CurrentDateTime'", m_db)) {
    SqlDataReader r = cmd.ExecuteReader();
    while (r.Read() == true) {
      sqlTime =  (DateTime)r'"CurrentDateTime"';
    }
  }
} catch (InvalidOperationException e) {
  Console.WriteLine(e.StackTrace);
  sqlTime = DateTime.Now;
} catch (SqlException e) {
  Console.WriteLine(e.StackTrace);
  sqlTime = DateTime.Now;
} finally {
  m_db.Close();
}