Function to_date() Help!
This is a multi-part message in MIME format. ------=_NextPart_000_009C_01BEBEF9.62D7B330 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable What are the parameters of function to_date() when i work with datetime = datatypes? Example: DEFINE dtoday DATETIME year to second; DEFINE mask varchar(19); =20 LET dtoday =3D to_date('1999-26-06 10:30:00' , mask) =20 =BFWhat to be the format mask? mask=3D '%Y-%m-%d ??????' ??? =20 Thank you very much!! =20 Alejandro Delu Buenos Aires - Argentina alejandro_delu@siu.edu.ar ------=_NextPart_000_009C_01BEBEF9.62D7B330 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 = HTML//EN"> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>What are the parameters of function to_date() when i = work with=20 datetime datatypes?</FONT></DIV> <DIV><FONT size=3D2>Example:</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>DEFINE dtoday DATETIME year to second;</FONT></DIV> <DIV><FONT size=3D2></FONT> <DIV><FONT size=3D2>DEFINE mask varchar(19);</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV></DIV> <DIV><FONT size=3D2>LET dtoday =3D to_date('1999-26-06 10:30:00' ,=20 mask)</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>¿What to be the format mask?</FONT></DIV> <DIV><FONT size=3D2>mask=3D '%Y-%m-%d ??????' = ???</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Thank you very much!!</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Alejandro Delu</FONT></DIV> <DIV><FONT size=3D2></FONT><FONT color=3D#000000 size=3D2>Buenos Aires - = Argentina</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2><A=20 href=3D"mailto:alejandro_delu@siu.edu.ar">alejandro_delu@siu.edu.ar</A></= FONT></DIV></BODY></HTML> ------=_NextPart_000_009C_01BEBEF9.62D7B330--