Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get max date
Message
From
05/07/2017 04:05:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Get max date
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01652423
Message ID:
01652423
Views:
66
Sir I am trying to get maximum date from smalldatetime column
For this I am using this command
select  max(convert(varchar(10),vou_date,103))as max_date from payments
but it is not showing correct date.

Please see attachment

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform