SQLite - Date Formatting within SQL Statement

Hello.

DB = SQLite
Language = VB6

I have a SQL query that groups my data by YEAR and MONTH, and has a field called Date that holds the date of each record as the Last Day of the Month.

2009-01-31
2009-02-28
2009-03-31
2009-04-30
...

The query works without any problems doing this. However, I would like the dates in the Date field to actually appear as...

mm/dd/yyyy or dd/mm/yyyy depending on how the user has his/her computer set as the date format.

==========

Here is how my string looks right now.

"SELECT date(Date, 'start of month', '+1 month', '-1 day') as Date, Open, High, Low, Close FROM prcTable GROUP by Year, Month"

Can anyone suggest how I can implement the required format?

Thanks.

Rich

What is the data type for your column?