NI Home
Cart Cart | Help
Company Events Academic NI Developer Zone Support Solutions Products & Services Contact NI MyNI

Up to Documents in NI Developer Zone Community
Currently Being Moderated

Converting the Date/Time String in the Database Toolset to the SQL Query Format

VERSION 4

Created on: Apr 1, 2009 11:05 AM by MargaretF. - Last Modified:  Aug 7, 2009 12:18 PM by MargaretF.

Functional Description

You can use the attached VI to convert strings that are output as a date/time yyyy-mm-dd hh:mm:ss format from the DB Tools Format Datetime Str VI to a mm/dd/yyyy hh:mm:ss AM/PM format that is accepted by a SQL query.

 

Database_String_Converter_LV86.png

 

Downloads:
Tags: database_toolset, date/time, db_tools, sql, labview
Average User Rating
(1 rating)
Comments (1)
Apr 1, 2009 1:51 PM
Todd Sierer Todd Sierer  says:

Could you include a screenshot of the code?  Thanks!

More Like This

  • Retrieving data ...

More by MargaretF.

View MargaretF.'s profile

Legal

This content (includes attachments) has been made available by community members, whom are solely responsible for such content. National Instruments does not support this content, and does not guarantee its quality in any way. NATIONAL INSTRUMENTS MAKES NO WARRANTIES, EXPRESS, STATUTORY OR IMPLIED, WITH RESPECT TO THIS CONTENT, INCLUDING WITHOUT LIMITATION ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE, NON-INFRINGEMENT OF INTELLECTUAL PROPERTY, OR ANY OTHER WARRANTIES THAT MAY ARISE FROM USAGE OF TRADE OR COURSE OF DEALING. For details regarding support of such content, please contact the author. For further legal information, please visit http://ni.com/legal/termsofuse/unitedstates/us/.