![]() With 3 implicit decimals: store 150 and it will be used as 0.150 With 2 implicit decimals: store 150 and it will be used as 1.50 (correct) With 1 implicit decimals: store 150 and it will be used as 15.0 With 0 implicit decimals: store 150 and it will be used as 150 With 3 explicit decimals: store 1,50 and it will be used as 1.500īut if you must store the Hours in an INT, then check 'Use implicit decimals' and make sure the INT is used everywhere with exactly 2 implicit decimals, because: With 2 explicit decimals: store 1,50 and it will be used as 1.50 With 1 explicit decimals: store 1,50 and it will be used as 1.5 With 0 explicit decimals: store 1,50 and it will be used as 1 If you can store the Hours in a fixed-point decimal, uncheck 'Use implicit decimals'. To store 9 decimals explicit, you need at minimum a DECIMAL(10,9) type to be able to store 1.000000000 ( fixed-point-types.html ).ĭo not try not to use float or double for financial data, as the types are not precise ( problems-with-float.html ). If you use explicit decimals, then data is stored as if there is a decimal comma. Integer calculations are faster and more accurate. If you have a number with 9 decimals, 1.000000000 for example, it is stored as 1000000000, for example in a BIGINT type. MySQL connection preferences when registeredĪ note on implicit decimals: simply said, with implicit decimals (or implied decimals), the decimal places are converted to INT. You can find the MySQL settings under the Preferences. MySQL connection preferences when unregistered (all fields are disabled) ![]() Simply closing this window will save your registration. If you have received your serial number, enter your Paypal email address and serial number in the appropriate fields at the bottom of the 'About…'-window. I am asking you to take action yourself, because email addresses on file are not always actual anymore. ![]() If you have donated for ICSviewer in the past, please e-mail me your Paypal transaction-reference and I will e-mail you your serial number. If you make a donation, in return you'll get a serial number mailed to your Paypal email address which removes the limitation and any 'unregistered' messages. You can keep on using it unregistered forever, but then you cannot use the MySQL export feature. You only have to do this once.Īs of v3.0, SetEXIFData is shareware. To allow ICSviewer to run on your system, start the application the first time by a right-click on its icon and choosing 'Open':Īnd then confirm that you want to open it. When you start ICSviewer the first time, macOS might warn you about the application being from an unidentified developer. ICSviewer can export the calendar data via copy/paste, into a CSV or directly into a MySQL table. I made it because I use iCal / Calendar / Bus圜al for keeping track of worked hours, but these apps do not calculate those hours for me, or you. This is a tool to convert an (exported) calender (.ics-file) into a table-formatted data grid, while calculating the hours you worked. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |