> Hello.
>
> I'm using SQLite with a VB wrapper (dhSQLite) for VB6.
>
> The following SQL string works fine for putting together a recordset where
> the DATE field contains only the date of the last day of each month.
>
>
> SQLString = "SELECT date(Date,'start of month','+1 month','-1 day') as
> Date, " & _
> "First(Open,ID) as Open, Max(High) as High, " & _
> "Min(Low) as Low, Last(Close,ID) as Close FROM [" & sTable &
> "] GROUP By Year, Month"
>
>
> Each record represents the Open, High, Low, Close price for a complete
> month, and is represented by the last day of the month.
>
> So we have...
>
> 2009-01-31
> 2009-02-28
> 2009-03-31
> 2009-04-30
> ...
>
> It is currently in the yyyy-mm-dd format.
>
> The line "date(Date,'start of month','+1 month','-1 day') as Date" is what
> formats the month date to be the last day of the month.
>
> MY PROBLEM:
>
> I would like the date format to be either (mm/dd/yyyy) or (dd/mm/yyyy)
> depending on the user's system date format.
>
> In the US, we use mm/dd/yyyy.
>
> I'm completely lost on how to do this within the SELECT statement above.
>
> Can someone suggest?
>
> Thanks.
>
> Webbiz
select strftime ('%m/%d/%Y', Date,'start of month','+1 month','-1 day') from ...
--
Zaga
You have worked and not worked. Not working is the hardest work of all.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
