I have my codes working where I got separate date and time columns. I would like to add one more column which have both date and time in. For the existing codes this how I did
sprintf(all,'%02d:%02d:%02d.%06u%03u',CURDATE(),s / 3600, (s % 3600) / 60, s % 60, usec, nsec)
I tried this does not work and got error too many argument for format and also format expect type inta but argument has 16 has type achar *a
sprintf(all,'%02d:%02d:%02d.%06u%03u',CURDATE(),'CURDATE() %02d:%02d:%02d.%06u%03u',s / 3600, (s % 3600) / 60, s % 60, usec, nsec,s / 3600, (s % 3600) / 60, s % 60, usec, nsec)
I need the space between the curdate and time ?