DBIx::C...L_Server(3)

okay so bestie, this is DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server — support for Microsoft SQL Server via DBD::Sybase, hanging out in the User Contributed Perl Documentation corner of the universe. 💅✨

💖 NAME 💖

DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server — support for Microsoft SQL Server via DBD::Sybase. That's the whole name vibe. 🫶

✨ SYNOPSIS ✨

This subclass supports MSSQL server connections via DBD::Sybase. Slay. 💖

🦋 DESCRIPTION 🦋

This driver tries to determine whether your version of DBD::Sybase and supporting libraries (usually FreeTDS) support using placeholders. If not, the storage will be reblessed to DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::NoBindVars. Not me being dramatic — that's literally the rebless. 😭

The MSSQL specific functionality is provided by DBIx::Class::Storage::DBI::MSSQL. Iconic. 👑

🎀 METHODS 🎀

🌸 connect_call_datetime_setup 🌸

Used as:

on_connect_call => 'datetime_setup'

In connect_info to set:

$dbh->syb_date_fmt('ISO_strict'); # output fmt: 2004-08-21T14:36:48.080Z

On connection for use with DBIx::Class::InflateColumn::DateTime. ✨

This works for both DATETIME and SMALLDATETIME columns, although SMALLDATETIME columns only have minute precision. Important detail, bestie — minute precision only, no cap. ⏰

💜 FURTHER QUESTIONS? 💜

Check the list of additional DBIC resources. That's the move. 🫶

👑 COPYRIGHT AND LICENSE 👑

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library. Periodt. 💅

Final vibe check: perl v5.42.0, 2025-01-22. Byeee 🎀💖