How to find nearest date in select sql

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to find nearest date in select sql

Message

18/01/2007 09:04:56

18/01/2007 09:00:24

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Divers

Thread ID:

01186568

Message ID:

01186589

Vues:

for eg.

ldStart = {^2006-03-01}
ldEnd = {^2006-04-01}

sum(quantity)*sum(price)/sum(quainty) catch for the average price at sales and buyings