ANSI SQL

Home » Data Access, Manipulation & Batch Languages »» ANSI SQL

1
2
3
4
5
6
7
»
»»

Date Conversion

Hi All,i have a directory such as; find /home/pavi/ctl/INFOSCAN.KKK.*.*.ctl* -exec ls -ltr {} \; | awk -F" " {'print $6 " " $7'} the output is : Jul 25 can anyone please suggest me how do I convert the above Date into YYYYMMDD FORMAT. Thanks pavi...

2 answers | 313 bytes |

Date calculation...please help...

Hi,I'm trying to find the difference between two dates (w/times) in terms of hours...can someone please modify the below pseudo-query so it does that, thanks.select (date1 - date2)from table1;...

2 answers | 222 bytes |

Date arithmetic in Crystal SQL help

Does anyone know the appropriate syntax for doing the pl/sql equivilent of: WHERE DATE_V >= SYSDATE - 364/365. I am aware of the CurrentDate function and have tried several incarnations of code but none seem to work. Google only returns one semi close reference to what I want to do....

0 answers | 296 bytes |

date

i,ve a table, tb_aduan. in this table there is a field where i save a date. i save the date as system date. i want to retrieve all the info for certain date. how can i do that. can someone help me.plzzzzzzzzzzzzzzzzzzzz...

6 answers | 224 bytes |

Database work

Hello!I'm new here on the forum!I have a work to do on a class which consists on creating a database and this's a work by checkpoints,which means,I have a limit date to give away part of the work I've done until the next checkpoint.The prob lem is,I don't know where to start!...

6 answers | 714 bytes |

database user post extraction

please can anyone help me i have a ipb forum some how i accidently delete my post i have a old backup from 3 week ago how can i extract the post from the backup NOTE: the only post that was deleted was post made by me none of the other member post was deletedi did not want to restore the entire...

4 answers | 1041 bytes |

Database triggers

How are the DMLs commited in the database triggers internally as they are based on a table and any table commit will commit all the pending transactions which could lead to problems.I want to know the flow or algorithm of implicit commit of dbtriggers.Thanks...

1 answers | 278 bytes |

Database task???

Hi all,I have some question,1. How many databse task are there in the SQL server 2000?2. How database task does?thank for reading...

0 answers | 152 bytes |

database of field trips from a daycare (was "Help with building a query")

I am working on a database design and since I'm new to SQL, I want to test the feasibility of the design before I commit to it. That is, I want to make sure that it is possible to build a single (and thus, fast) query to look up the data I need. The database is for a control system with lot...

14 answers | 2049 bytes |

database inconsistencies

creating an asp page that deals with an SQL database. when i try to display all records in table x, not all show up. so "select * from x" does not work within the asp but it does work if i use SQL.also, if i deal with the database directly, i have to "commit;" after each statement or table x rev...

3 answers | 354 bytes |

database for portal

Hi all,I am looking a schema of database de example for portal, where I can find any document for this?Thanks...

0 answers | 129 bytes |

Database Deisgn for MES/Industrial Automation

My company is in the early design stages of a medium MES application. We are looking for a guide of some sort to help explain to our customer how important database design is before we log any data to the database.Has anyone seen or used a document that may aid us in this critical step? any an...

0 answers | 394 bytes |