System() Function

The System() function executes an operating system command and returns its output as a string. This function is useful for performing external operations, such as running commands on the operating system.

Syntax

System(string command)

Parameters

command (string): The operating system command to execute.

Example

Getting the Current Date and Time

SELECT System('date')

SELECT System('date')

This example executes the date command, which returns the current date in the format YYYY-MM-DD.

Getting the Current Time

SELECT System('time')

This example executes the time command, which returns the current time in the format HH:MM:SS.

Running a Command

SELECT System('dir')

This example executes the dir command, which lists the files and directories in the current directory. The output will vary depending on the operating system.

Notes

Use this function with caution, as it can introduce security vulnerabilities if not used properly. Always validate and sanitize any input to prevent command injection.