Re: Sql mdb

Thank you Mike date ok but time should be
with a POINT at list for me 07.00.00 you gave me a lead
thanks shlomo
As for date (my last quest) is the date field (time) a string??
Becouse i used it as a date format
i wander if...
Do you know of a function to convert date/time to mdb format?


"MikeR" <nf4lNoSpam@xxxxxxxxx> wrote in message
news:47b1ab55$1@xxxxxxxxxxxxxxxxxxxxxxxxx
limelect wrote:
I have moved from pardox to mdb
On paradox i could split the time and date on 2 fields
Now my record stil hase time and date separetly
I need to make an sql on date and time
1.How can i do it
2. I tried with sql startdate=11/09/2008 no luck dose not filter at all
(no error)
3. I tried with sql startdate='11/09/2008' error
4. I tried with sql startdate="11/09/2008" error
5 I tried with sql startdate=11/09/2008 0:0 error
P.S the filed hase only date no time .should i include time,I cannot!!
Are you trying to make a select query, or an update or insert? Trying to
build an SQL string?

The date and time delimiter in an mdb database is # and the date must be
mm-dd-yyyy and time is hh:mm:ss if the field in the database is a
datetime.
SQL := 'Select * from table where startdate = #11-09-2008#';

You can concatenate the date and time, separated by a space.
Startdate := '#' + date + ' ' + time + '#';

Mike


.

Relevant Pages

  • Re: Problems with Delete Command
    ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need help with Code Please!!!
    ... posted in response to my last post was some SQL, but this is not the SQL that ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • RE: Web Part and Access database
    ... I dont know if it is possible to connect to access,but you can download SQL ... Server Error in '/Webparts' Application. ... The connection string specifies a local Sql Server Express instance ... String user, String password, Boolean trusted, String connectionString) ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: INDEXES: BTRIEVE vs EXTFH (cobol)
    ... Bill Bach wrote: ... In SQL, you can specify just about anything, but at the lower MKDE ... the engine has to pick the right Btrieve ... When COBOL needs to find this value, it knows that the key is a string. ...
    (comp.databases.btrieve)
  • Re: INDEXES: BTRIEVE vs EXTFH (cobol)
    ... In SQL, you can specify just about anything, but at the lower MKDE ... the engine has to pick the right Btrieve ... When COBOL needs to find this value, it knows that the key is a string. ...
    (comp.databases.btrieve)