Community

• 

  Permanently deleted user

  • January 05, 2016 11:10

  Hello,
  
  Not directly in FLL but you can use the SQL Statement GETDATE() to get this information from an SQL Server.
  For example the following code will get the current date time for an sql server.
  
  

  String connection = "Enter ConnectionString here";
  String select =  "SELECT GETDATE() AS CurrentDateTime";
  String searchString;
  
  PrepareRecordset( connection, select);
  StringArray recordArray = Record(connection, select, 0);
  searchString = recordArray.GetAt(0);
  print(searchString);
  SearchText: searchString;

  
  
  I hope this helps you further.
  
  
  
  
  

  No 0 Yes
• 

  TripleD

  • January 05, 2016 18:32

  Works a treat. Thank you

  No 0 Yes

Please sign in to leave a comment.