G
Guest
I have a table look like this:
ID Name Trade_Date Settle_Date
1 AA Company 20070903 20071005
2 BB Company 20070904 20070910
3 ABC Insitute 20070905 20070913
4 ST Shop 20070906 20071021
----------------------------------------------------------------------------------------
My Question1:
I need an SQL Qeury,
to select all items where the Trade_date is greater 2007/Sep/05
----------------------------------------------------------------------------------------
Question 2:
Do i have to adjust the date format eg: dd/mm/yyyy or /mm/dd/yyyy or
dd/mmm/yyyy , something like that ?...
Thank you very much ! ! ^_^!
ID Name Trade_Date Settle_Date
1 AA Company 20070903 20071005
2 BB Company 20070904 20070910
3 ABC Insitute 20070905 20070913
4 ST Shop 20070906 20071021
----------------------------------------------------------------------------------------
My Question1:
I need an SQL Qeury,
to select all items where the Trade_date is greater 2007/Sep/05
----------------------------------------------------------------------------------------
Question 2:
Do i have to adjust the date format eg: dd/mm/yyyy or /mm/dd/yyyy or
dd/mmm/yyyy , something like that ?...
Thank you very much ! ! ^_^!