NAME

DBIx::XMLServer::DateTimeField - date and time field type

DESCRIPTION

This class implements the built-in date and time field type of DBIx::XMLServer. The where and value methods are overridden from the base class.

where method

$sql_expression = $date_time_field->where($condition);

The condition may consist of one of the numeric comparison operators '=', '>', '<', '>=' or '<=', followed by a date and time. The date and time may be in any format understood by the Date::Manip package, such as '2003-11-03 21:29:10' or 'yesterday at midnight'.

Alternatively, the condition may be empty, in which case the SQL expression is

<field> IS NOT NULL .

If the condition is the character '!', then the SQL expression is

<field> IS NULL .

value method

The date and time is returned in the format 'YYYY-mm-ddThh:mm:ss', as required by the xsi:datetime type in XML Schema.

SEE ALSO

DBIx::XMLServer::Field

AUTHOR

Martin Bright <martin@boojum.org.uk>

COPYRIGHT AND LICENCE

Copyright (C) 2003-4 Martin Bright

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.