VBcoders Guest



Don't have an account yet? Register
 


Forgot Password?



Build SQL Date Expressions

by Eugenio Y. (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Beginner
Date Added: Wed 3rd February 2021
Rating: (9 Votes)

If you want to build an application that can work with several database engines, the main problem you will have to deal with is the different ways for specifying date expressions.
This class will allow you to forget those differences. You can enter date strings in any format "dd/mm/yy", "mm/dd/yy", etc.. The class will validate the correctness of the date string and convert it into an expression you can use. Works for SQLServer, MySQL, Access, Informix and Oracle, and it's easy to add more engines.

Assumes
It's my first submission after downloading tons of code.. hope it's useful. Vote for it.

Rate Build SQL Date Expressions

Download Build SQL Date Expressions

Download Build SQL Date Expressions (4 KB)

Build SQL Date Expressions Comments

No comments have been posted about Build SQL Date Expressions. Why not be the first to post a comment about Build SQL Date Expressions.

Post your comment

Subject:
Message:
0/1000 characters