thanks Michael, but my column type is timestamp.
*Midana Fernandes Sana*
*"* *O filho sábio atende à instrução do pai; mas o escarnecedor não ouve a
repreensão**."*
2013/5/2 Michael Moore <michaeljmo...@gmail.com>
> SQL> describe mytab99
> TABLE mytab99
> Name Null? Type
>
> ----------------------------------------- --------
> ----------------------------
> MYDATE DATE
>
> SQL> insert into mytab99 (mydate) values (sysdate)
> 1 row created.
> SQL> commit
> Commit complete.
> SQL> select * from mytab99
>
> MYDATE
> ---------
> 02-MAY-13
> 1 row selected.
>
>
> On Thu, May 2, 2013 at 4:05 PM, Midana <mida...@gmail.com> wrote:
>
>> how can I insert sysdate.
>>
>> insert into trajetoria values ('Ir pra Faculdade',
>>
>> ListaPosicaoTempoEspaco_ty(*to_timestamp(sysdate,'DD-MON-RRRR HH:MI PM')
>> *,
>> SELECT REF(pg) FROM pontogeografico
>> pg WHERE pg.latitude = '-3.728876' and longitude = '-38.521006'),
>> SELECT REF(u) FROM usuario u WHERE u.NOME
>> = 'Midana');
>>
>> --
>> --
>> You received this message because you are subscribed to the Google
>> Groups "Oracle PL/SQL" group.
>> To post to this group, send email to Oracle-PLSQL@googlegroups.com
>> To unsubscribe from this group, send email to
>> oracle-plsql-unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/Oracle-PLSQL?hl=en
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "Oracle PL/SQL" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to oracle-plsql+unsubscr...@googlegroups.com.
>>
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to Oracle-PLSQL@googlegroups.com
> To unsubscribe from this group, send email to
> oracle-plsql-unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "Oracle PL/SQL" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/oracle-plsql/3IXDcW7JlrE/unsubscribe?hl=en
> .
> To unsubscribe from this group and all its topics, send an email to
> oracle-plsql+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
---
You received this message because you are subscribed to the Google Groups
"Oracle PL/SQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to oracle-plsql+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
