If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Simple DateTime Query question

Hi,
I am trying to access a table which has a tgame_datetime field with data_type 'DECIMAL'.The values in this field are long values like '1,102,148,345,000' ,'1,102,148,346,000' ,'1,102,148,347,000' etc.
I can access them and format them later on,but what I need is that I should be able to run a query depening upon specific dates.So,if I try this or formatted dates(YYYY/MM/DD HH:MMS):

select gr.game_id,gr.game_datetime from game_results as gr,game as g where gr.tournament_id=g.tournament_id and gr.tournament_datetime between '1,102,148,345,000' and ''1,102,248,345,000'