Date/Region In SQL CE

From: Den (anonymous_at_discussions.microsoft.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 05:31:06 -0700

Hi,

I am developing an app in C# on a PDA using SQL CE.
It is to use British date format : dd/mm/yyyy.
I am having problems with the comparison of dates between dates entered in the app and the database.
I can format the dates in C# and then format dates using convert in SQL and compare the two..

However , I was wondering is it possible , when programmatically creating a database , to set the region and or date to British format.I would like to ensure that the default formatting for any date field is British.
If it's not possible to set the format for the whole database is it possible to specify the format in a create table statement or to add some type of constraint to ensure the date is formatted correctly.

Thanks,
Den

Relevant Pages

  • Re: GEDOM as a database format
    ... industrial-strength SQL databases like SQL Server and Oracle. ... I worked in the area of multi-dimensional database ... your database to some format that the utility understands, ... Subject: re GEDCOM ...
    (soc.genealogy.computing)
  • Re: Create Non Access DB with VB??
    ... but then that isn't really a database. ... Application and the "MDB" file format, yet their is a distinction between ... > And then just write a VB app to interact with one of those! ... You could also do it with ASP using either Access or SQL ...
    (microsoft.public.vb.database)
  • Re: GridView basics
    ... I must format is e.Row.DataItem.ItemArray, ... On 31 aug, 14:56, "Eliyahu Goldin" ... database. ... end up with a bulky sql. ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Linking SQL Server 2000 to Access - Bigint datatype
    ... I'm using Access 2003 to generate the database, ... I did try converting it to Access 2002-2003 format using the ... >> I'm currently trying to create an Access database that has links to SQL ... I've narrowed down the issue to the bigint datatype; ...
    (microsoft.public.sqlserver.odbc)
  • Re: Linking SQL Server 2000 to Access - Bigint datatype
    ... I'm using Access 2003 to generate the database, ... I did try converting it to Access 2002-2003 format using the ... >> I'm currently trying to create an Access database that has links to SQL ... I've narrowed down the issue to the bigint datatype; ...
    (microsoft.public.sqlserver.server)
Quantcast