Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding Date + Time
Message
De
14/09/2010 17:52:36
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
À
14/09/2010 17:09:49
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01481160
Message ID:
01481175
Vues:
34
This message has been marked as a message which has helped to the initial question of the thread.
If this is raw sql then this will work as well. Sql Anywhere will automatically convert a properly formatted string to datetime. In fact if the time part is 00:00 then you can leave that off as well.
SELECT * FROM RO
 WHERE cast(cast(Last_Date as char(10))+' '+Last_Time as datetime) as datetimecol > '2000-01-01 00:00:00'
>I have a weird situation here. The client has a SQL Anywhere backend with a table having a Last_Date and Last_Time fields. Both are of type Date and Char. On the server, I have a timestamp. Basically, I need to get all the records from the client over the timestamp. This is quite complicated as they store the date and time in two different fields. How can I query that?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform