Access Date Format

  • Thread starter Thread starter Goh
  • Start date Start date
G

Goh

Hi guy,
How can we make sure the date format that we pass in MS Access are
constantly the format that we wish.
I ask this is because My select statement work in some computer and some
not. Even I have check the computer system date format there are same. What
will effect the date format in MS Access. How to prevent this thing happen.
I can't use access anymore if it work like that.

Thanks in advance,

With regards,
Goh
 
Use parametrised query instead, something like: select * from somewhere
where datefield = ?
 
I assume you are dealing with globalization issues (i.e., some comupters
belonging to people in some countries have different date formats). If so,
switch to a common globalization setting before saving to the database.

http://www.c-sharpcorner.com/Code/2005/April/GlobalizationusingASP.NET.asp

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************
 
Hi Goh,

I agree with Miha, that we can use parameterized query to overcome the
format issues.

In addition, the MS Access stores DateTime with 8 bytes. It doesn't stores
any format information in the database. The format/culture information is
used according to the machine's regional settings.

Kevin Yu
Microsoft Online Community Support

============================================================================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
============================================================================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Back
Top