The Merit Matters Blog has info for module developers on passing dates and regional settings through GP to SQL Server. If you develop for GP or want to develop for GP or simply have some strange need to know, give it a look.
Dynamics GP Regional Settings and Server Time Format
Archived post from 2008. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.