Solved

VB 4.0 & Informix 6.0 DateTime Query

Posted on 1998-06-07
2
573 Views
Last Modified: 2008-02-26
I have a Informix 6.0 and VB 4.0 and used  ODBC. I can use sql query for returning recordset of text, integer and other data field.
My problems is how to query DateTime data fields. My date fields is in yyyy/mm/dd hh:nn:ss formats in Informix.

0
Comment
Question by:sujatha060198
2 Comments
 
LVL 4

Accepted Solution

by:
yowkee earned 50 total points
Comment Utility
Just treat it as string.
For example, there is a table

Create table TabTest
(
  MyDate  DATETIME
)

SQL statement for query for the datetime field,

  select * from TabTest
  where DATETIME = '1998/06/08 14:46:22'

eg, In you code(assume DAO)

  ' db is the database object
  Dim rst As RecordSet
  Dim sSQL As String

  sSQL = "Select * from TabTest where MyDate = '" + _
         Format(Now, "yyyy/mm/dd hh:mm:ss") + "'"
  Set rst = db.OpenRecordset(sSQL, dbOpenSnapshot, dbReadOnly)
 

 
0
 

Author Comment

by:sujatha060198
Comment Utility
Informix datetime format also are in the format of '1998-06-08 14:46:22'. So one must make sure in which format they are before making the date time.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now