Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
From SQL Server to SQL Anywhere
Message
De
09/09/2010 12:00:30
 
 
À
09/09/2010 11:23:17
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01480681
Message ID:
01480688
Vues:
45
>Kevin pointed out that you need to declare the data types. I usually quote the dates with this format.
>
>
>DECLARE @Last_Date  datetime
>DECLARE @Last_Time time 
>
>SET @Last_Date='1899-12-30 00:00:00'
>SET @Last_Time='00:00:00'
>
>
>There may be a date setting that will accept the date you used?
>
>Sql Anywhere also will accept ansi standard syntax instead of T-Sql. A small example.
>
>
>begin 
>DECLARE @Last_Date  datetime;
>DECLARE @Last_Time time ;
>
>SET @Last_Date='1899-12-30 00:00:00' ;
>SET @Last_Time='00:00:00' ;
>if <some condition> then 
>
>end if ;
>
>end 
>
Thanks
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform