Home
Analogues
This section contains 1010data analogues for Excel and SQL users.
1010data for Excel users
1010data can solve the same problems that you are used to solving in Excel in one or more ways. Sometimes there are direct translations between the two, and sometimes a unique solution is needed in order to arrive at the same result.
Function comparisons
You know how to use certain functions in Excel, but you want to know how to complete the same tasks using 1010data's functions. While some Excel functions have a direct match to a function in 1010data, others match to a combination of functions/operations. The following sections show some of the analogous functions between Excel and 1010data.
Date and Time Functions

Date and Time Functions


Excel Function	1010data Function	Description
`NOW()`	`@now_`	Returns the current date and time.
`HOUR(serial_number)`	`hour(X)`	Returns the hour portion of a time-related value.
`MINUTE(serial_number)`	`minute(X)`	Returns the minutes portion of a time-related value.
`SECOND(serial_number)`	`second(X)`	Returns the seconds portion of a time-related value.
`DAY(serial_number)`	`day(X)`	Returns the day portion of a date-related value.
`MONTH(serial_number)`	`month(X)`	Returns the month portion of a date-related value.
`YEAR(serial_number)`	`year(X)`	Returns the year portion of a date-related value.
`WEEKDAY(serial_number,[return_type])`	`dayofwk(X)`	Returns the integer value corresponding to the day of the week of a date-related value.
`DAYS(start_date,end_date)`	`days(X;Y)`	Returns the number of days between two date-related values.