Welcome to the dbFunctions.js JavaScript library. This library provides a set of functions that bring SQL-like functionality to JavaScript, making it easier to handle dates, strings, and other types directly in your web projects.
To interactively try all the functions and see documentation - visit DbFunctions Documentation and Playground
Each function in the dbFunctions.js library comes with a detailed description, parameter list, and examples. See the source code here:
To use dbFunctions.js in your project, include the following script tag in the head of your HTML documents. Preferable, download the file and reference locally.
<script src="https://www.ddginc-usa.com/js/dbFunctions.js"></script>
Here are a few examples of how you can call functions from the dbFunctions.js library:
// Example: Adding days to a date let newDate = dbf.add_days(new Date(), 10); // Example: Getting the age difference let age = dbf.age('1999-01-01', '2020-02-22'); // Example: Formatting a date to MM/DD/YYYY let fmtDate = dbf.to_char(new Date(),'MM/DD/YYYY');
Function | Category |
---|---|
add_days | Date |
add_months | Date |
age | Other |
ascii | String |
charindex | String |
choose | Other |
chr | String |
coalesce | Other |
concat | String |
curdate | Date |
curtime | Date |
current_date | Date |
current_time | Date |
current_timezone | Date |
date_add | Date |
date_format | Date |
date_part | Date |
date_trunc | Date |
dateadd | Date |
datediff | Date |
datename | Date |
datepart | Date |
day | Date |
dayname | Date |
dayofmonth | Date |
dayofweek | Date |
dayofyear | Date |
defaultdateformat | Date |
eomonth | Date |
field | Other |
format | Date |
getDaysInMonth | Date |
getJulianDayNumber | Date |
getdate | Date |
greatest | Other |
hex | Other |
iif | Other |
initcap | String |
instr | String |
isdate | Date |
isleapyear | Date |
isnumeric | Other |
julianday | Date |
last_day | Date |
lcase | String |
left | String |
least | Other |
like | String |
lower | String |
lpad | String |
ltrim | String |
month | Date |
monthname | Date |
months_between | Date |
next_day | Date |
next_month | Date |
next_quarter | Date |
next_week | Date |
next_year | Date |
now | Date |
nullif | Other |
nvl | Other |
parse_url | Other |
patindex | Other |
previous_day | Date |
quote_nullable | Other |
quotename | Other |
repeat | String |
replicate | String |
reverse | String |
right | String |
round | Numeric |
rpad | String |
rtrim | String |
soundex | String |
space | String |
str | String |
str_to_date | Date |
strftime | Date |
string_agg | String |
string_escape | String |
stuff | String |
substr | String |
sysdate | Date |
this_month | Date |
this_quarter | Date |
this_week | Date |
this_year | Date |
time_slice | Date |
to_char | String |
to_date | Date |
to_hex | Other |
to_number | Numeric |
to_roman | Other |
today | Date |
translate | String |
translate_format | String |
trim | String |
trunc | Numeric |
ucase | String |
unhex | Other |
unistr | String |
unixepoch | Date |
unix_timestamp | Date |
upper | String |
year | Date |