411 Aug 2016 @ 10:18 PDTDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsHi,this solution worked but its giving wrong value for one id 4 alone
310 Aug 2016 @ 02:33 PDTDatabaseReplyOptions to compare contents of two tablesIn our project we use minus, so i feel its good way.
210 Aug 2016 @ 12:31 PDTDatabaseReplyConvert text to a timestamp sel to_timestamp('june 7,2016,12' ,'Month DD,YYYY,HH') Try This It worked for me
110 Aug 2016 @ 12:16 PDTDatabaseReplyconvert varchar data into timestamp sel cast('2016-08-03 08:32:03' as timestamp format'yyyy-mm-ddbhh:mi:ss') This Worked for me Try once