date difference function in netezza

SQL Statement conversion Format function cast, convertBoth cast and convert are often used. Specially extracted as an article, convenient to find.Both cast and convert can perform data type conversions. In most cases, the two perform the same function, but the convert also provides some special date format conversions, and cast does not have this function.Since c

Copy codeThe Code is as follows:/** Time Difference obtained, in the format of year-month-day hour: minute: Second or year/month/day hour: minute: Second* The year, month, and day are in full format, for example, 01:00:00* Return accuracy: seconds, minutes, hours, days*/Function GetDateDiff (startTime, endTime, diffType ){// Convert the time format of xxxx-xx to the format of xxxx/xxStartTime = startTime. r

Copy codeThe Code is as follows :/* * Time Difference obtained, in the format of year-month-day hour: minute: Second or year/month/day hour: minute: Second * The year, month, and day are in full format, for example, 01:00:00 * Return accuracy: seconds, minutes, hours, days */ Function GetDateDiff (startTime, endTime, diffType ){ // Convert the time format of xxxx-xx to the format of xxxx/xx StartTime = star