如何将日期作为参数从php传递到postgres

$date = '2022-10-15';

$host = 'your_host';
$port = 'your_port';
$dbname = 'your_dbname';
$user = 'your_username';
$password = 'your_password';

$conn = new PDO("pgsql:host=$host;port=$port;dbname=$dbname;user=$user;password=$password");

$sql = 'SELECT * FROM your_table WHERE date_column = :date';
$stmt = $conn->prepare($sql);
$stmt->bindParam(':date', $date);

$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);