Answers

Apr 25, 2007 - 01:15 AM
I dont know if it will work with vb.net but u can tweak the SQL that u use and format the date
eg
Dim strSQL As String = "SELECT f1, f2, f3, format(f4,'Short Date') FROM TableName ORDER BY f4 DESC;"
eg
Dim strSQL As String = "SELECT f1, f2, f3, format(f4,'Short Date') FROM TableName ORDER BY f4 DESC;"

Apr 25, 2007 - 01:32 AM
yes it should work, I tried it in C#

Apr 25, 2007 - 01:32 AM
I used OleDbCommand and OleDbDataReader to read it and treat the datefield as a string
i.e.
OleDbCommand oleCmd = new OleDbCommand("SELECT format(mydtefld,'short date') FROM tblDates", oleConn);
and gettting that value worked like this
Console.WriteLine(oleRead.GetString(0).ToString());
so yes, u should be able to use the format command. It does mean u have to specify each column in your query though
i.e.
OleDbCommand oleCmd = new OleDbCommand("SELECT format(mydtefld,'short date') FROM tblDates", oleConn);
and gettting that value worked like this
Console.WriteLine(oleRead.GetString(0).ToString());
so yes, u should be able to use the format command. It does mean u have to specify each column in your query though

Apr 26, 2007 - 12:25 PM
One note: oleRead.GetString(0) returns a string, so why do you add a .ToString() to it?
Cheers
Peter
Cheers
Peter

Apr 26, 2007 - 02:45 PM
Thanks!
Add New Comment