Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Once again thank you for your prompy advise.
What happen if I would like to search for date range query?
Eg. given 2 dates for any records that are between these
2 dates. Could you show me some examples on how to achieve
the results. Excuse me for being a newbie in SQL. Thanks.
>>In SQL 6.5, the DATE data type comes with Date and Time.
>>Hence the storing of date field without a given time, the
>>SQL will set a default time.
>>
>>I just wonder, how could we make a SQL query with only
>>date input by user? Must I hard code the Time to search
>>for any date range queries? Pls advice.
>
>Try the 'LIKE' clause
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement