Industry Online Support
Technical Forum
Navigation
WinCC Flex datetime format SQL dd/mm/yyyy instead of mm/dd/yyyy
Created by: Dilli at: 11/22/2010 7:56 PM (2 Replies)
Rating 
Thanks 3
3 Entries
| 11/22/2010 7:56 PM | |
|
Posts: 122 Rating:
|
Hi to all here ! Need some help, I want to log some data into SQL data base, i'm using functions described here http://support.automation.siemens.com/WW/llisapi.dll?func=cslib.csinfo&objId=24248681&load=treecontent&lang=en&siteid=cseus&aktprim=0&objaction=csview&extranet=standard&viewreg=WW One of row is datetime format, and I get the current time with function now(), the SQL, as i know, works only with mm/dd/yyyy, but my Regional Settings is configured to show the date dd/mm/yyyy and i don't want to change it, is it possible to convert the result of function now() to return mm/dd/yyyy despite my configuration ? |
| 11/23/2010 2:37 PM | |
|
Posts: 122 Rating:
|
thanksRamonT, i've added the time and it works MyDate = Month(Now()) & "/" & Day(Now()) & "/" & Year(Now()) & " " & Hour(Now()) & ":" & Minute(Now())& ":" & Second(Now())
|
This contribution was helpful to
|
|
Follow us on