function MySQLTimeStampCompatibleString(timestamp){ return new Date(timestamp).toISOString().substring(0, 19).replace('T', ' '); } function queryWithTimestampLongValues(fromTime, toTime) { var query = ""; if(fromTime && toTime){ query += 'SELECT * FROM user_info WHERE user_info.created_at > TIMESTAMP("' + MySQLTimeStampCompatibleString(fromTime) + '") AND user_info.created_at < TIMESTAMP("' + MySQLTimeStampCompatibleString(toTime) + '")'; } return query; }
Simplify data collection in your JS app with a fully integrated form management platform. Includes support for custom question types, skip logic, integrated CCS editor, PDF export, real-time analytics & more. Integrates with any backend system, giving you full control over your data and no user limits.
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)