<div>
Would something like this work for price?<br />
<br />
PriorOpen` decimal(45) NOT NULL DEFAULT ''<br />
<br />
and how about for the GMT time:<br />
<br />
`DateGMT` timestamp(45) NOT NULL DEFAULT '',
</div>


Would something like this work for price?

PriorOpen` decimal(45) NOT NULL DEFAULT ''

and how about for the GMT time:

`DateGMT` timestamp(45) NOT NULL DEFAULT '',

<div>
sorry, that did not make sense.
</div>


<div>
<div class="content wysiwyg-content">
Can someone suggest what field is best to use and the best way to handle and store and create currencies fields. But there will be various currencies there (USD, JPY, etc.)<br />
<br />
Also, is there some special way to handle GMT times?<br />
<br />
Thanks!
</div>
</div>


Can someone suggest what field is best to use and the best way to handle and store and create currencies fields. But there will be various currencies there (USD, JPY, etc.)

Also, is there some special way to handle GMT times?

Thanks!

currency field in mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.